Count is not correct after after a visual filter

[Anonymous]

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 case,

Device2 was operated 6 times and

Device4 was operated 1  time
I added another visual to know the total of devices:  In this case 2 devices: 

(The count depend on the time range indicated by the slicer)

My issue is when I added a filter to the visual table to show only devcies that have been operated more than 1. The Count is not updated. It should  be 1. How can I do to count the devices based in the filter on the visual table? 

Thank you.

[v-yalanwu-msft · Accepted solution]

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]

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

[ribisht17]

@Anonymous 

You can just make use of the simple measure here, Why do we need a Table?

Count of Device = (DISTINCTCOUNT(Device[Device]))

Thanks,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

[Anonymous]

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

[tamerj1]

Hi @Anonymous 

what is the current code of the measure?

[Anonymous]

Hi:

I dont have any measure.