Double Filter

[Chema_Ortega_Ga]

Hello everybody! I hope you all are very good!!!

I have a Table with data, and I want to show in the report how many of then suffer fron CONGESTION in their communications. The requirements is that it only shows the number when congestion has happened more thay five times:

By now, this is working good. But now they tell me they want to know how many Users have such occurrence more than 5 times.. I have developed a measure:

Users CONGESTION =

CALCULATE(

    DISTINCTCOUNT('GCC_COSTS AUTO_COST_OUTPUT'[User]),

        FILTER('GCC_COSTS AUTO_COST_OUTPUT',[remote_action_get_wi_fi_signal_strength_execution_outputs_AdjacentChannelsCongestion]=1)

        )

And the result is:

Which numbers are correct when I have in mind all the occurrences. BUT, the Card does not allow me to make the same filter:

So I got 79 users instead of two Users, which is an error. How can I also filter this second card to make it a ppear Users = 2?

Thanks a lot! Best regards,

Cheema Ortega

[Anonymous · Accepted solution]

Hi @Chema_Ortega_Ga ,

I created a sample pbix file(see the attachment), please check if that is what you want.

Users CONGESTION = 
VAR _tab =
    SUMMARIZE (
        'GCC_COSTS AUTO_COST_OUTPUT',
        'GCC_COSTS AUTO_COST_OUTPUT'[User],
        "@CONGESTION", CALCULATE ( SUM ( 'GCC_COSTS AUTO_COST_OUTPUT'[CONGESTION] ) )
    )
RETURN
    COUNTROWS ( FILTER ( _tab, [@CONGESTION] > 5 ) )

Best Regards

[Chema_Ortega_Ga]

Hi v-yiruan-msft,

Thanks a lot! I think you've worked it out. SOOO MUCH APPRECIATED!!!!

Chema

Thanks a lot. Best regards!

Chema Ortega

[Ritaf1983]

Hi @Chema_Ortega_Ga 

Please provide a workable sample data and your expected result from that. It is hard to figure out what you want to achieve from the description alone.  

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...