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.

[@rameshkandi]

Thank you for your knowledge sharing 👍

[@nivethav7951]

Clear Explanation. Thank you.

[@sayi77]

excellent explanation as always

[@vikramkukkadapu9761]

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

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

[@killerof21121989]

Thanks!

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

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

[@ArifulIslam-gs6uy]

Very Nice

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

[@44.7b.kaharaditya6]

Very useful formula, thanks

[@GoodlyChandeep]

Glad it was helpful!

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

[@veera8853]

Can you explain Combination of Hasonevalue and allexcept

[@thanomnoimoh9299]

Best describe ever

[@GoodlyChandeep]

Glad you like it! 💚

[@SamehRSameh]

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

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

[@deepag805]

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

[@momosy9413]

How to contact you to take yours courses

[@GoodlyChandeep]

[e-mail]

[@venkatareddykummitha5863]

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

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