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 )
)

     

amitchandak's avatar
amitchandak
Super User
4 years ago

tangerinemdr15 , Try a measure like

Sumx(filter(summarize(Table, Table[Claim#], "_sum", sum(Table[Amount]) , "_cnt", calculate(DistinctCount(Table[Payment Type]), filter(Table, Table[Payment Type] in {"REG","ALT"} ))),[_cnt] =2), [_sum])

tangerinemdr15's avatar
tangerinemdr15
Helper I
4 years ago

amitchandak Thank you so much! that was perfect! I realized, though, that I needed to modify my question. what would be the measure for this result? I would like to see only those with ALT and Reg or only ALT.  Sorry!

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

    Share the download link of your PBI file.