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 

 

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

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