Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

CALCULATE + FILTER +ALL

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 month...
CALCULATE
DAX
Filter
  • VahidDM's avatar
    VahidDM
    4 years ago

    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's avatar
Anonymous
Not applicable
4 years ago

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

 

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    VahidDMno problem and how ?? pbix is not supported here