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

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