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

Anonymous's avatar
Anonymous
Not applicable
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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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