Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Count is not correct after after a visual filter

Hi: I have a table with the next data: Device name, time when the device was operated, # of operations I added a table  to count how many times the device recorded  an operation. In this cas...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ;

    In your screenshot, the fillter condition only apply on one visual. as count of Device , it don't have filter.

    so we could create a measure on another visual to keep sync.

    cout = CALCULATE(DISTINCTCOUNT('Table'[Device]),FILTER('Table', CALCULATE(COUNT('Table'[Device]),ALLEXCEPT('Table','Table'[Device]))>1))

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous ;

In your screenshot, the fillter condition only apply on one visual. as count of Device , it don't have filter.

so we could create a measure on another visual to keep sync.

cout = CALCULATE(DISTINCTCOUNT('Table'[Device]),FILTER('Table', CALCULATE(COUNT('Table'[Device]),ALLEXCEPT('Table','Table'[Device]))>1))

The final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you! It is was I needed. It is working perfectly.