Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Double Filter

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 th...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,

    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