DAX HASONEVALUE Function

[@enocharthur4322]

It's amazing how well you're able to simplify things like this. You're a Goat!!! Thanks

[@letsexcel5579]

I'm now feeling bad for not finding you all these days. Fantastic Explanation 😊

[@sixtyfiveroses2968]

I've just started learning DAX this week, but this was very well explained that even I understood it. Thank you very much for this. Subbed!

[@joaorataoo]

Congratulations.
Again very well explained and clear.
Keep up the great work.

[@mohamedchatar4393]

Great explanation thank you ! i've become addicted to your videos because of your way of simplifying things !

[@GoodlyChandeep]

Haha.. thanks Man. Hopefully this addition serves you well. 😁

[@wayneedmondson1065]

Hi Chandeep. Thanks for this quick lesson. Very well explained and interesting. Thanks for sharing. Thumbs up!!

[@GoodlyChandeep]

Thanks Wayne for watching all my tutorials :)

[@vikramkukkadapu9761]

awesome man. really very helpful to me. Pls.. do videos like this

[@rameshkandi]

Thank you for your knowledge sharing 👍

[@joaorataoo]

I would like to ask you a question regarding the use of the Matrix visual.
As an example use the Matrix that you used in your video.
You have the Year and the Month.
Suppose I want a partial total per Year/Month, but not the Year/Total, nor do I want the word Total to appear.
thanks

[@GoodlyChandeep]

Hi Joao,
Is there any logic for Partial Total ? Partial for what period ?
If you can help me understand the problem, I can look into it :)

[@joaorataoo]

​@@GoodlyChandeep In this video by Curbal, she explains how to show the Total without showing the subtotal. What I want is the exact opposite, showing the subtotals without showing the grand total.
th-cam.com/video/58a2rIV2nYg/w-d-xo.html

[@jagans6409]

sir, thank you for the video!! can you please explain from where the Total appeared in the visual? Is 'Total' calculated by the Visual or is it already there in the data file.

wow I loved your channel... You just got a subscriber!

[@GoodlyChandeep]

Welcome aboard!

[@nivethav7951]

Clear Explanation. Thank you.

[@sayi77]

excellent explanation as always

[@ardenzhuo9351]

Thanks for this great video! but one question, could you kindly explain why sumx(values) is required/how do we read that portion?
if(HASONEVALUE('Country Only'[Country]),[Q1 Shipment Amt US$],sumx(values('Country Only'[Country]),[Q1 Shipment Amt US$]))

[@usmansharifshaik1187]

sir, could you provide powerbi file for this hasonevalue video?
i need to know how did you put year and month in a table at 1:20 ?
pls let me know sir. i want to know. thanks in advance.

[@momosy9413]

How to contact you to take yours courses

[@GoodlyChandeep]

[e-mail]

[@kavinduwijerathne7216]

This helped! Thanks

[@44.7b.kaharaditya6]

Very useful formula, thanks

[@GoodlyChandeep]

Glad it was helpful!

[@veera8853]

Can you explain Combination of Hasonevalue and allexcept

[@SamehRSameh]

How can i add hasonevalue with distict count
Evey month distinct count but in total return avg all months

[@venkatareddykummitha5863]

How to rectify wrong values at the total level in a measure.

[@ArifulIslam-gs6uy]

Very Nice

[@thanomnoimoh9299]

Best describe ever

[@GoodlyChandeep]

Glad you like it! 💚

[@deepag805]

Bro explanation is good .unable to catch you..too fast

[@sravankumar1767]

Has one value can only use in months and years or any other

[@GoodlyChandeep]

You can write it on any column of a table. I used Months as an example.

[@killerof21121989]

Thanks!