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,...
distinctcount
Filter
  • v-robertq-msft's avatar
    v-robertq-msft
    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.

v-robertq-msft's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
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.