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.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you ribisht17 , but that measure is not enough. I need to apply a filter to the count as @ v-yalanwu-msft mentioned.