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/


     

     
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

 

      • VahidDM's avatar
        VahidDM
        Icon for Super User rankSuper User
        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/