Regarding retrieving data

[Uma_Dhandpani]

Actually, in matrix table, I used slicer to filter.When I click certain filter ,its corresponding values(i.e)column 1 value want to be displayed, if selecting all in filter want a value which is apart (i.e)column 2 value want to be display

[v-diye-msft · Accepted solution]

Hi @Uma_Dhandpani ,

You are referring to dynamically changing column displayed by slicer selection, please check below similar posts:

https://community.powerbi.com/t5/Desktop/Column-Displayed-in-a-table-Based-on-Slicer-Selection/m-p/4...

[Uma_Dhandpani]

The first image denotes the field I have and second , the report to be .Default, it should display the Total_Amount value, when I click on the filter (i.e) dollar/euro/rupee, it should display the Base_Amount value

[v-diye-msft · Accepted solution]

Hi @Uma_Dhandpani ,

It seems your description is a little bit different with above post, I've created a pbix based on your question:

Measure = 
IF (
    HASONEVALUE ( 'Table 2'[Currency Mode] ),
    IF (
        SELECTEDVALUE ( 'Table'[Attribute] ) = "BaseAmount",
        CALCULATE (
            MAX ( 'Table'[Value] ),
            FILTER ( 'Table', [Attribute] = "BaseAmount" )
        )
    ),
    IF (
        SELECTEDVALUE ( 'Table'[Attribute] ) = "Total amount",
        CALCULATE (
            MAX ( 'Table'[Value] ),
            FILTER ( 'Table', [Attribute] = "Total amount" )
        )
    )
)

pbix attached.

[v-diye-msft · Accepted solution]

Hi @Uma_Dhandpani ,

You are referring to dynamically changing column displayed by slicer selection, please check below similar posts:

https://community.powerbi.com/t5/Desktop/Column-Displayed-in-a-table-Based-on-Slicer-Selection/m-p/4...

[v-diye-msft]

Hi @Uma_Dhandpani ,

Could you please show more details with expected data?