topic Re: CALCULATE + FILTER +ALL in DAX Commands and Tips

CALCULATE + FILTER +ALL

Anonymous — Wed, 19 Jan 2022 21:37:50 GMT

Hello guys,

I have following table

month

And I need to create measure that will return count of month and not be affected by selection/filter of months, I create this DAX formula, but for unknown reason it is not working, any reason why? and what should be correct syntax ?

measure= CALCULATE(DISTINCTCOUNT(Table[month]),ALL(Table,Table[month])))

Re: CALCULATE + FILTER +ALL

Anonymous — Wed, 19 Jan 2022 21:43:45 GMT

I also tried

measure

= CALCULATE(DISTINCTCOUNT(Table[Month]),ALL(Table[Month]))

but when I changed filter on the page this measure is updated as well, instead of to be fixed

Re: CALCULATE + FILTER +ALL

VahidDM — Wed, 19 Jan 2022 21:49:30 GMT

HI Anonymous

Try this:

measure= CALCULATE(DISTINCTCOUNT(Table[month]),ALL(Table[month]))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: CALCULATE + FILTER +ALL

Anonymous — Wed, 19 Jan 2022 21:52:54 GMT

Hell Vahid this is what I mentioned in 2nd post (I have typo here with ")") but it doesn t work

Re: CALCULATE + FILTER +ALL

VahidDM — Wed, 19 Jan 2022 21:58:31 GMT

Anonymous

Can you share you PBIX file?

or try this if you set a filter on month and you want to ignore that:

measure = CALCULATE ( DISTINCTCOUNT ( Table[Month] ), REMOVEFILTERS ( Table[Month] ) )

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: CALCULATE + FILTER +ALL

Anonymous — Wed, 19 Jan 2022 22:12:33 GMT

VahidDMno problem and how ?? pbix is not supported here

Re: CALCULATE + FILTER +ALL

VahidDM — Wed, 19 Jan 2022 22:14:10 GMT

Anonymous

upload it on https://wetransfer.com/ and share the link here.

Re: CALCULATE + FILTER +ALL

Anonymous — Wed, 19 Jan 2022 22:18:36 GMT

VahidDM

here is it

https://we.tl/t-PP2hH4VRwQ

Re: CALCULATE + FILTER +ALL

VahidDM — Wed, 19 Jan 2022 22:24:15 GMT

Anonymous

You set a filter on Date column so use one of these:

count_m_fix = CALCULATE(DISTINCTCOUNT(Sheet1[y_m]),ALL(Sheet1))

count_m_fix = CALCULATE(DISTINCTCOUNT(Sheet1[y_m]),ALL(Sheet1[Date]))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: CALCULATE + FILTER +ALL

Anonymous — Wed, 19 Jan 2022 22:26:46 GMT

VahidDM got it...I was filtering on the different column than filter was set up in the report

count_m_fix = CALCULATE(DISTINCTCOUNT(Sheet1[y_m]),ALL(Sheet1[Date]))

is correct in my case, we were right, I just switch the filter 😄

thank you so much for participation

Re: CALCULATE + FILTER +ALL

Anonymous — Wed, 19 Jan 2022 22:28:13 GMT

Also find it, few minutes after you 😄 kudos sent 🙂