Show only selected Company value

Hi rajasekaro 

Since Company is on Columns, visual-level filtering alone is NOT enough.
You must control the measure value returned per company.

Step 1: Base measure (example)

Assume you already have something like:

Amount :=

SUM ( 'Fact'[Amount] )

Step 2: Currency-based visibility measure

Create a new measure:

Amount (Currency Rule) :=

VAR curr = SELECTEDVALUE ( 'Currency'[Currency] )

VAR comp = SELECTEDVALUE ( 'Company'[Company] )

RETURN

SWITCH(

    TRUE(),

    -- INR → only company 00030

    curr = "INR" && comp = "00030",

        [Amount],

    -- USD → all except 00030

    curr = "USD" && comp <> "00030",

        [Amount],

    -- hide everything else

    BLANK()

)

Step 3: Use this measure in the Matrix

1. Replace Amount with Amount (Currency Rule) in Values
2. Matrix settings:
• Format → Values → Show items with no data = OFF
• Format → Columns → Stepped layout = OFF (optional, cleaner)

Result

Power BI automatically removes matrix columns that return only BLANK().

Important Notes

• Currency slicer must be single-select (radio button = perfect)
• Company slicer can stay All
• This works even with Totals and hierarchies

Optional: Keep Total Correct

If your Total is wrong (common issue), use:

Amount (Currency Rule) :=

VAR curr = SELECTEDVALUE ( 'Currency'[Currency] )

RETURN

SUMX(

    VALUES ( 'Company'[Company] ),

    VAR comp = 'Company'[Company]

    RETURN

        SWITCH(

            TRUE(),

            curr = "INR" && comp = "00030", [Amount],

            curr = "USD" && comp <> "00030", [Amount],

            BLANK()

        )

)

If you want:

• Company slicer to auto-change
• Currency coming from fact rows
• RLS version
• Performance-optimized version for large data

tell me which one and I’ll tailor it.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!