Forum Discussion
Need to show different Measure values based filter selections
- 6 years ago
we need to use "isfiltered"(or other functions) to identify if a filter is applied.
https://community.powerbi.com/t5/Desktop/Show-result-in-table-only-if-it-is-filtered/td-p/586917
for filters in any table, we need to use "isfiltered" for each slicer(column) per table.
in my example, filter1 show filters in "geo table", filter2 show filters in "sample data",filter1 show filters in "weight table".
Measure = VAR filter1 = ISFILTERED ( 'geo table'[country name] ) VAR filter2 = ISFILTERED ( 'sample data'[person id] ) VAR filter3 = ISFILTERED ( 'weight table'[region] ) RETURN IF ( ISFILTERED ( 'sample data'[question desc] ), 37, IF ( filter1 || filter2 || filter3, 39, IF ( NOT ( filter1 && filter2 && filter3 ), 37 ) ) )result1, 3
result 2
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
we need to use "isfiltered"(or other functions) to identify if a filter is applied.
https://community.powerbi.com/t5/Desktop/Show-result-in-table-only-if-it-is-filtered/td-p/586917
for filters in any table, we need to use "isfiltered" for each slicer(column) per table.
in my example, filter1 show filters in "geo table", filter2 show filters in "sample data",filter1 show filters in "weight table".
Measure =
VAR filter1 =
ISFILTERED ( 'geo table'[country name] )
VAR filter2 =
ISFILTERED ( 'sample data'[person id] )
VAR filter3 =
ISFILTERED ( 'weight table'[region] )
RETURN
IF (
ISFILTERED ( 'sample data'[question desc] ),
37,
IF (
filter1 || filter2
|| filter3,
39,
IF ( NOT ( filter1 && filter2 && filter3 ), 37 )
)
)
result1, 3
result 2
Maggie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Maggie,
Superb and great solution. it worked for me well.
Thanks again.
Regards,
Bala