Values Function DAX
Вставка
- Опубліковано 11 вер 2024
- Learn how the VALUES function works in DAX.
Download Power BI File - www.goodly.co....
- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -
goodly.co.in/l...
✔️ Power Query Course-
goodly.co.in/l...
✔️ Master Excel Step by Step-
goodly.co.in/l...
✔️ Business Intelligence Dashboards-
goodly.co.in/l...
- - - - Blog - - - -
www.goodly.co....
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!
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.
You explain it in a brilliant way!
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
Perfect, Simple, and elegant way of explanation. Thank you for your efforts
Glad you liked it!
Great video - you keep it simple and concise and explained clearly.
Very well explained. Tanks you so much
Finished watching
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.
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.
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?
Thanks
Values can also take a table right?
Hello great video,i would like to ask what does keepfilter(values(table)) in a calculate neasure mean?thanks a lot!
Hi good video,
Sumx values function over rides if statement
Great video. thanks. Why can't we remove the duplicate values by distinct or equivalent function?
Great video.
Great Video!!! Thanks for sharing
Thanks for watching!
Thank you sir!
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?
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/
Awsome!
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?
Great video
Glad you enjoyed it
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
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 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.
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.
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