Forum Discussion

PowerBIUser007's avatar
PowerBIUser007
Regular Visitor
1 year ago

Filter a Matrix table by first row

Hello everyone, my first post as a fairly new powerbi user, I hope I'm in the right section of the forum. I have the following request: I have a table with customer names. Also 3 further measures ...
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi PowerBIUser007 ,

 

Don't know much about your data model, but you can try the following expression:

CustomerCMFilter = 
IF (
    HASONEVALUE('Customer'[CustomerName]),
    IF (
        [CM%] < 0.05,
        1,
        0
    ),
    1
)

DisplayMeasure = 
IF (
    ISINSCOPE('Customer'[CustomerName]),
    IF (
        [CustomerCMFilter] = 1,
        [Turnover],  // Replace with the measure you want to display
        BLANK()
    ),
    [Turnover]  // Replace with the measure you want to display for cost centres
)

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.