Forum Discussion

Sabri-All's avatar
Sabri-All
Regular Visitor
4 years ago
Solved

User filter doesn't apply on distinctcount

Hello,    I have two tables Orders (column: ID, accountId, date, type) Accounts (column: accountId, Name) The purpose is to get for every account the number of unique order types. For example,...
  • v-robertq-msft's avatar
    4 years ago

    Hi, 

    According to your description, I can roughly understand your requirement, I also created some sample data and I can successfully get the correct count value using the DAX formula:

    Count of unique order types =
    
    CALCULATE(DISTINCTCOUNT(Orders[type]),ALLSELECTED(Orders))

    Then I go to check the interaction type between the slicer and the visuals to make sure they are enabled:

     

    And I can get what you want, like this:

     

    You can download my test pbix file below

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.