Values Function DAX

Learn how the VALUES function works in DAX.
Download Power BI File - www.goodly.co.in/wp-content/u...
- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
- - - - Blog - - - -
www.goodly.co.in/blog

[@saifullahkhan3776]

Bro's explanation is so eloquent that sometime I kind of felt listening to Radio FM.

[@GoodlyChandeep]

hah!. Good one!

[@pravinshingadia7337]

Great video - you keep it simple and concise and explained clearly.

[@timuratazhanov6553]

You explain it in a brilliant way!

[@amitharajkumar7916]

Perfect, Simple, and elegant way of explanation. Thank you for your efforts

[@GoodlyChandeep]

Glad you liked it!

[@joaopinaledo9675]

Very well explained. Tanks you so much

[@vishaljhaveri7565]

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.

[@VoodooBlue90210]

Very well explained and liked the way you showed how it can cause an error and how to fix the error. Subscribed 👍

[@GoodlyChandeep]

Thanks for the sub! Glad it helped

[@gursikh133]

Great Video!!! Thanks for sharing

[@GoodlyChandeep]

Thanks for watching!

[@zaharterentev2091]

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?

[@PDannyBlanco]

Great video.

[@chaitanyat8298]

Excellent explanation.. That a beginner can also easily understand..

[@GoodlyChandeep]

Glad to hear that

[@chaitanyat8298]

@@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.

[@dilipinamdar5523]

Thank you sir!

[@user-lm5wb8vi1x]

Finished watching

[@nsnear]

Great video. thanks. Why can't we remove the duplicate values by distinct or equivalent function?

[@carolinecostaBR]

Awsome!

[@vimukthiamarasena6264]

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?

[@thomastsopelas9213]

Hello great video,i would like to ask what does keepfilter(values(table)) in a calculate neasure mean?thanks a lot!

[@giri41]

Hi good video, Sumx values function over rides if statement

[@muhammedriyasthekkekara8894]

Thanks

[@usmansharifshaik1187]

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?

[@AWBL]

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?

[@statesman6379]

His function returned both the list of names and the count instead of just the count.

[@sandeepjami9119]

Great video

[@GoodlyChandeep]

Glad you enjoyed it

[@chriskeo392]

Values can also take a table right?

[@galellopez4214]

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.

[@GoodlyChandeep]

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 :)

[@baldeepsinghnagi8943]

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

[@neerpanwar]

Values(region) returns a table of distinct region (based on filter) over which concatenate function iterates and concatenate.

[@shikharbhardwaj1352]

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...

[@GoodlyChandeep]

goodly.co.in/learn-dax-powerbi/

[@SMITDEDHIA96]

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.)

[@GoodlyChandeep]

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!

[@krantikumar894]

What is the diff bw DISTINCTCOUNT & VALUES

[@neerpanwar]

@@krantikumar894 values includes blanks as well.. distinct doesnt show blank value

[@neelanshunisingh971]

Can a Measure accepts the non scalar value ?or here some other context is used.

[@GoodlyChandeep]

Measures can never have a non scalar output.. a measure can input a table but the output should always be a scalar value

[@daXcel7448]

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 ?.

[@GoodlyChandeep]

Pavan, in Excel PowerPivot you cannot create a table using DAX.

[@vinodkumarhs4000]

Can we able to use values function in power pivot

[@GoodlyChandeep]

I think yes.

[@vishaljhaveri7565]

Ochu khabar padi.

[@giri41]

Can you please

[@databubbles6095]

Why you are running about the great topic.. because of that couldn't understand by multiple pauses of video