Forum Discussion

tangerinemdr15's avatar
tangerinemdr15
Helper I
4 years ago
Solved

Filtering on a Matrix

Hi,  This may be a simple solutuion, I dont use Power BI much. I'll include a sample of the issue. In a matrix, is there any way to only show rows if it has certain criteria?  Here is the underlyin...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Ah, I see... But always up for a challenge. Try this as a filter:

    FILTER 2 =
IF (
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Payment Type] ),
        ALLEXCEPT ( 'Table', 'Table'[Claim #] )
    ) = 2,
    1,
    IF ( MAX ( 'Table'[Payment Type] ) = "ALT", 1 )
)

     

PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago

Ah, I see... But always up for a challenge. Try this as a filter:

FILTER 2 =
IF (
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Payment Type] ),
        ALLEXCEPT ( 'Table', 'Table'[Claim #] )
    ) = 2,
    1,
    IF ( MAX ( 'Table'[Payment Type] ) = "ALT", 1 )
)

 

tangerinemdr15's avatar
tangerinemdr15
Helper I
4 years ago

PaulDBrown thank you so much! This works! I appreciate your time!