Forum Discussion
Uma_Dhandpani
7 years agoHelper I
Regarding retrieving data
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 apar...
- 6 years ago
Hi Uma_Dhandpani ,
You are referring to dynamically changing column displayed by slicer selection, please check below similar posts:
- 6 years ago
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
7 years agoCommunity Support