CALCULATE + FILTER +ALL

[Anonymous]

Hello guys,

I have following table

month

1

2

3

4

5

6

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

[VahidDM]

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/

[Anonymous]

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

[VahidDM]

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

[Anonymous]

@VahidDMno problem and how ?? pbix is not supported here

[VahidDM]

@Anonymous 

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

[Anonymous]

@VahidDM 

here is it

https://we.tl/t-PP2hH4VRwQ

[Anonymous]

@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

[VahidDM · Accepted solution]

@Anonymous 

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

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

or 

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/

[Anonymous]

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

[Anonymous]

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