Forum Discussion

AS1234's avatar
AS1234
New Member
3 years ago

DAX Count function that can ignore slicer?

Hi,

 

I am looking to write a measure that counts the number of distinct IDs in a table that ignores the month slicer. Regardless of what month is selected in the slicer, I want the result to be 4.

 

Example data:

 

ID     Month

1       July

2       March

3     

4     October

 

Anyone have any ideas?

Need Help

2 Replies

  • zemorex's avatar
    zemorex
    Icon for Advocate I rankAdvocate I
    3 years ago

    Perhaps you can use REMOVEFILTERS(YourDateTable[Months])? See if that works.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi AS1234 ,

     

    Try this:

    DistinctIDCount = CALCULATE(DISTINCTCOUNT(Table[ID]), ALL(Table[Month]))

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum