As PowerBI has various options to slice and dice the data, it is very mandatory to understand the filter context on the PowerBI report.
Filter Context can be applied on various levels
Let us take a scenario where the user wants to capture the filters applied to the specific field.
To demonstrate this scenario, I create a simple table as like below.
I need to use Description field on the table to filter the data.
If the user selects the checkbox then it should show the selected value. If it is a single selection, then show the value. If users select multiple values, then show as “Mulitple”.
Place the description field on the page level filter and see the outcome.
Use the below DAX script to achieve the result.
Parameter Selection =
HASONEVALUE ( Parameters[Value] ),
“Selection” & VALUES ( Parameters[Description] ),
NOT ( ISFILTERED ( Parameters[Description] ) ),