Hello, thank you for your videos and sharing. Please, what you recommend to use to solve such problem. I want to use VALUES in another measure to find the unique values of column, but before this I need to filter this column by custom condition. What method I should to use?
VALUES Function works like Remove Duplicates of Excel. Input-> A single column. Syntax-> VALUES( tbl [ column A ] ) Returns a single columnar table which has distinct values of column A. If you are using a Matrix Table while plotting the Measure = VALUES( tbl [ column A ] ), then turn off SubTotals.
Hi chandeep, when i turn off the subtotals and then drag values measure to matrix visualization , it's again giving same error (multiple values supplied ). i am using latest version aug 2021 pbi . what else need to be turn off to show the values in my visualization?
Great video Chandeep! Just curious, can we also perhaps replace the IF function with a shortened version "Measure 2 = COUNTROWS(VALUES(Date[Names]))" Any issues using this expression vs the IF function / expression?
@@GoodlyChandeep can u share me any videos on Dax ,I am beginner and I need to get grip on that..your explanation is very nice,simple to understand any complex one.
hi, goodly good explanation. i have seen that extract data from a different table using VALUES function.(without having a relationship) could you please explain this?
I am using value function to display the filter content in form of tile.. like i have a slicer for region and i created a measure that is = concatenatex ( values(region), region, ",") and using this i can see in tiles thr filters that i am selecting.. how is this working ..i want to know how this measure is working
Thanks a lot for this video - I have struggled with the VALUES() function. (But now on, I think I won't :) ) But I have one doubt - How is this different from DISTINCTROWS() function? (sorry if this question is silly as I'm new to DAX.)
There isn't a DISTINCTROWS function in DAX, although there is DISTINCT and DISTINCTCOUNT function. 1. DISTINCT - Can accept a single column or a full table and will return a column or table with unique values or unique rows respectively. 2. DISTINCTCOUNT - Is going to count the number of unique values in the column specified. Hope this helps!
Hi Goodly, Greetings from Honduras. Thanks a lot for this video Great. I have a request, It's possible that can make a video how to create passwords for reports or dashboards. Or how to open an specifict report by region using URL.
1. In Power BI the most secure way of sharing your report with someone is via Power BI Service.. and not through a web-link protected with password. 2. I din't understand your second question, can you please elaborate ? thanks for stopping by :)
clear ,concise n very well explained. Thank u for making such amazing videos.
Bro's explanation is so eloquent that sometime I kind of felt listening to Radio FM.
hah!. Good one!
Very well explained and liked the way you showed how it can cause an error and how to fix the error. Subscribed 👍
Thanks for the sub! Glad it helped
You explain it in a brilliant way!
Hello, thank you for your videos and sharing. Please, what you recommend to use to solve such problem. I want to use VALUES in another measure to find the unique values of column, but before this I need to filter this column by custom condition. What method I should to use?
VALUES Function works like Remove Duplicates of Excel.
Input-> A single column.
Syntax-> VALUES( tbl [ column A ] )
Returns a single columnar table which has distinct values of column A.
If you are using a Matrix Table while plotting the Measure = VALUES( tbl [ column A ] ), then turn off SubTotals.
i like the way u explain stuff.
Perfect, Simple, and elegant way of explanation. Thank you for your efforts
Glad you liked it!
Hello great video,i would like to ask what does keepfilter(values(table)) in a calculate neasure mean?thanks a lot!
Great video - you keep it simple and concise and explained clearly.
It not just returns single column table or scalar value but if a table is provided as input then it returns a whole table
Hi chandeep, when i turn off the subtotals and then drag values measure to matrix visualization , it's again giving same error (multiple values supplied ).
i am using latest version aug 2021 pbi . what else need to be turn off to show the values in my visualization?
Very well explained. Tanks you so much
Hy...do you have full DAX series ...if any payment need to be done ..i can go with that too...I liked the way you have told the VALUE function...
goodly.co.in/learn-dax-powerbi/
Great video Chandeep! Just curious, can we also perhaps replace the IF function with a shortened version "Measure 2 = COUNTROWS(VALUES(Date[Names]))" Any issues using this expression vs the IF function / expression?
His function returned both the list of names and the count instead of just the count.
Great video. thanks. Why can't we remove the duplicate values by distinct or equivalent function?
Excellent explanation..
That a beginner can also easily understand..
Glad to hear that
@@GoodlyChandeep can u share me any videos on Dax ,I am beginner and I need to get grip on that..your explanation is very nice,simple to understand any complex one.
hi, goodly good explanation. i have seen that extract data from a different table using VALUES function.(without having a relationship)
could you please explain this?
Values can also take a table right?
I am using value function to display the filter content in form of tile.. like i have a slicer for region and i created a measure that is = concatenatex ( values(region), region, ",") and using this i can see in tiles thr filters that i am selecting.. how is this working ..i want to know how this measure is working
Values(region) returns a table of distinct region (based on filter) over which concatenate function iterates and concatenate.
Hi good video,
Sumx values function over rides if statement
Can a Measure accepts the non scalar value ?or here some other context is used.
Measures can never have a non scalar output.. a measure can input a table but the output should always be a scalar value
Thanks a lot for this video - I have struggled with the VALUES() function. (But now on, I think I won't :) )
But I have one doubt -
How is this different from DISTINCTROWS() function? (sorry if this question is silly as I'm new to DAX.)
There isn't a DISTINCTROWS function in DAX, although there is DISTINCT and DISTINCTCOUNT function.
1. DISTINCT - Can accept a single column or a full table and will return a column or table with unique values or unique rows respectively.
2. DISTINCTCOUNT - Is going to count the number of unique values in the column specified.
Hope this helps!
What is the diff bw DISTINCTCOUNT & VALUES
@@krantikumar894 values includes blanks as well.. distinct doesnt show blank value
Great Video!!! Thanks for sharing
Thanks for watching!
Great video.
Thank you sir!
Hi Goodly, Greetings from Honduras. Thanks a lot for this video Great.
I have a request, It's possible that can make a video how to create passwords for reports or dashboards. Or how to open an specifict report by region using URL.
1. In Power BI the most secure way of sharing your report with someone is via Power BI Service.. and not through a web-link protected with password.
2. I din't understand your second question, can you please elaborate ?
thanks for stopping by :)
Can we able to use values function in power pivot
I think yes.
Awsome!
How can we achieve this in excel power pivot?. I get error when i use tis DAX. How to return a table in power pivot ?.
Pavan, in Excel PowerPivot you cannot create a table using DAX.
Finished watching
Thanks
Great video
Glad you enjoyed it
U are superman!
Ochu khabar padi.
Can you please
Why you are running about the great topic.. because of that couldn't understand by multiple pauses of video