DAX HASONEVALUE Function

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

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

[@nivethav7951]

Clear Explanation. Thank you.

[@rameshkandi]

Thank you for your knowledge sharing 👍

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

[@GoodlyChandeep]

Welcome aboard!

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

[@vikramkukkadapu9761]

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

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

[@sayi77]

excellent explanation as always

[@killerof21121989]

Thanks!

[@ArifulIslam-gs6uy]

Very Nice

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

[@44.7b.kaharaditya6]

Very useful formula, thanks

[@GoodlyChandeep]

Glad it was helpful!

[@thanomnoimoh9299]

Best describe ever

[@GoodlyChandeep]

Glad you like it! 💚

[@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$]))

[@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.
czcams.com/video/58a2rIV2nYg/video.html

[@veera8853]

Can you explain Combination of Hasonevalue and allexcept

[@deepag805]

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

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

[@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]

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