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

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'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