Power BI DAX Tutorial (13/50) - What is HasOnevalue function

[@ganeshbere007]

can u pls jst tell us what relation u have used to connect the productmaster & main Data / sales table, coz our total sales data not at all flashing infront of sub catagories

[@AnalyticswithNags]

Trim the product column in both table. Might be that will be reason

[@VinodKumar-zn8ty]

@@AnalyticswithNags Thanks for the Solution Sir. Same issue i was facing and struggled for so much time... Seen your response here and it solved

[@tanmoysaha3618]

When I'm dragging category name, name and total sales it's not coming in the table. Can u pls help me ? Is there any issue with data modeling ?

[@AnalyticswithNags]

Can you mail more details please, mail id in description.

[@hiteshjoshi3148]

did you fond the solution tanmoy it is happening with me.

[@RahulKumar-kf6ir]

Hi, There single space available before product name in Product Name column in the fact table. Solution :- Transform data --->> Go to the Fact table --->> selected Product Name Column -->> Under the Transform tab ----->>> under the Format --->>> trim

[@sass520]

At 6:44 what did you mean by each product has unique value so cost is shown. By values do you mean Category and Name level?I am confused

[@AnalyticswithNags]

Name level

[@kunwarmaurya2025]

Thanks for valuable knowledge. I analysed a scenerio: If we have a single product name under a category then for that category only this DAX doesn't work. 🙌🙌❤❤

[@AnalyticswithNags]

Ok

[@siddharthanich]

Hi Sir, For the measure 'CostPrice', you have used the SUM function. How is it showing individual cost prices (Like 700, 900 etc)? When i tried, it showed the total sum of Cost Price for that particular category. I had to use MAX or MIN to get this result. Any suggestions?

[@AnalyticswithNags]

I used cost price from product master

[@siddharthanich]

@@AnalyticswithNags haha.. sorry sir. Thank you so much. Am new to Power BI and am totally depending on your videos and it's really helping me and many of my friends to understand better.

[@adventuresofvyomandkeshav3036]

Thanku sir Your efforts by explaining every concept using a proper scenario is fabulous. But sir there was some lack of explanation in lastdate and it's related function. I didn't understand that concept. Apart from that videos from related functions are easily understandable and well explained. Sir I request you to pls make 2 or 3 video for datesinbetween, lastdate kind of time intelligence function. Sir you are a wonderful teacher. Thanku sir

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues. Will make video on date related functions

[@bhavanit56]

Hi sir i have one doubt After creating if has one value measure it is evaluating only name column of table How come category level total sales value is populated in chart at 7:28 time stamp without total sales measure in values column of chart pls help me sir...

[@AnalyticswithNags]

Not sure about your question

[@NoMercyNinja_]

Can you explain how you build relationship between sales and product master table? It’s not working on my end…

[@AnalyticswithNags]

Watch relationship video

[@ashwinkarki8112]

Hello sir since we have removed total sales from Values and inserted new salescost amt . Since we have removed total sales ,at first level how is the totals sales being shown in y axis?

[@AnalyticswithNags]

Watch it again. I hope you are referring at 7 mins 30 secs... You might have missed it. Your assumption is correct. But, As soon as I removed one measure I added immediately another measure

[@piyushpathak7311]

Sir create this DAX series playlist till the advance level ..

[@AnalyticswithNags]

Thanks for your feedback. Surely will add some advance concepts soon.

[@piyushpathak7311]

@@AnalyticswithNags thanks Sir waiting for it

[@ganeshbere007]

Sir, It is not at all filtering the data of product master, some thing is wrong.....pls help me out

[@AnalyticswithNags]

Ensure no space in product. Trim the product column in fact and dimension tables and then relate

[@chinnapureddysivanagireddy3824]

Hi sir, I need help. Scenario - I have 3 visuals in that 2 column charts and one is table. If i select value from one column chart then table data to be refreshed from same visual. And same way if I select from other column visual table data to be updated from same visual. But I select data in one column chart table is updated from both column charts.give me an idea to fix.

[@AnalyticswithNags]

Check about interaction

[@maniganesh1403]

hi sir i like to learn how you created the second table based on the existing table this one would be greatly useful can you please make a video for that

[@AnalyticswithNags]

Will upload soon

[@maniganesh1403]

Thank you sir

[@adilakshmichalagoni1360]

Hello Sir, Am trying to create new sales cost as u showed in the above video, However, If I select category and product name from product master table and total sales amount from sales table but sales amount showing blanks for each category and product in graph or table also new sales amount also showing blank for each row. Kindly help me with this. I gave relationship to product master and sales table with product name

[@AnalyticswithNags]

Check product column in both tables that you have created relationship. It has some blanks to use trim function to remove that space

[@shrutisharma1434]

Hello , When I am adding total sales in the chart after category name whole sales is showing under blank category . Why it is happening ?

[@AnalyticswithNags]

I hope the Product data not match with fact table product. Check no space in data

[@shrutisharma1434]

@@AnalyticswithNags In product table earlier it was showing blank when I was adding category or name in the slicer which I removed from the advance filter and also I have created relationship b/w sales and product table where I mentioned 'Many to one' in Cardinality and 'single' in cross filter direction, still when when I am adding total sales in the chart it is showing under blank category .

[@harshithabobolu7106]

Hi Nag, I have a question. When new costprice measure dragged under tooltip and at the first level it showed same as sales amount. However as per the logic written it should check the 'Name' column which will always have a single value. Could you please explain in detail.

[@AnalyticswithNags]

Watch video again

[@harshithabobolu7106]

Understood 😊

[@waseemalam9649]

When I use Drill Down option. Why Total Sales are showing in every Category. I want to see breakup Category of Total Sales .Please help Please Help

[@AnalyticswithNags]

Create relationships

[@balaroxx2700]

I had downloaded the data sets from the description but the dimdate not available Only the product master ,data,sheet1 these 3 datas are in that can u provide me the exact data u shown in the video which helps to follow up ❤

[@balaroxx2700]

There are 10 product names but u displayed only 4 names of it 3:48

[@llo.welc_me]

Hello Sir, I have one question though created the relationship b/w productmaster with sales as 1:M but when i try to plot the graph like you it is not shown category wise sales just only single column. can you help me regarding that

[@AnalyticswithNags]

May be data is different from sales and product master. Use trim function in both table join columns

[@Ramesh-d7d6o]

PLS SHARE ME THE LINK OF RELATIONSHIP VIDEO. I WAS NOT ABLE TO MAKE RELATIONSHIP WITH FACT & DIMENTION TABLE OF PRODUCT

[@waseemalam9649]

Drill Down option is not working

[@AnalyticswithNags]

Not sure

[@waseemalam9649]

Total Sales is showing in every Categaory. When I apply Drill Down It's Showing Total Sales not showing breakup Sales of Total

[@AnalyticswithNags]

Create relationships

[@jatinhingorani3704]

following this series, like the demonstration of dax, sir one feedback before demonstrating please also explain about that particular function.

[@AnalyticswithNags]

Sure will touch upon that in future videos.

[@sonikusum3]

HasOneValuesales_cost = IF(HASONEVALUE('Product Master'[Name]), After this [Cost Price] is not showing up in formula. Table relationship is good, I also trimmed the name column in both tables.

[@AnalyticswithNags]

You need to use Same column product master [Name] column in chart axis or in slicer and filter one value

[@sonikusum3]

@@AnalyticswithNags Thank you, it worked out. For some reason, cost price data type was set up as text. I corrected it to whole number.

[@gagansingh3481]

Provide excel material too with video sir

[@AnalyticswithNags]

If you Follow the DAX playlist, you can fuse the previous video files which will be in description

[@Zovi-kanu]

you are revolution on youtube great sir wonderful content I get my first job only after watching your vedios😇

[@AnalyticswithNags]

Thanks keep learning share this channel if you are in LinkedIn

[@Zovi-kanu]

@@AnalyticswithNags sure 😀

[@konerunithin1965]

Hi megha

[@siddheshdandagavhal9804]

If(HASONEVALUE('Product Master'[NAME]), [CostPrice], [Total Sales]). The above query gives the cost price if the Name field has only one value. Else it returns Total Sales.

[@aniruddhnain1550]

The problem statements are not clear

[@AnalyticswithNags]

Watch again

[@mostafazaki8451]

this video is really confusing with that way of explanation !!!

[@AnalyticswithNags]

Sorry to hear that

[@niftyoptionslivetradingand7231]

Very bad example chosen for HASONEVALUE hahahahahahaha..... sir you yourself so confused explaining this concept :-)....

[@AnalyticswithNags]

No confusion at all. My intension is to make people understand function with practical example. If you have any other simple function for this requirement let me know I will surely publish in new video.

[@hiteshjoshi3148]

When I'm dragging category name, name and total sales it's not coming in the table. Can u pls help me ? Is there any issue with data modeling ?

[@AnalyticswithNags]

Not sure what kind of error you are getting. Watch the video again and implement it again

[@hiteshjoshi3148]

@@AnalyticswithNags sir all cleared i just want to know your email address or your linkedin i want to ask you about customer segmentAtion and customer analytics.