Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Using a filter based on Multiple columns that can filter the whole report page ! including Measures

Greeting Everyone    i want to create a filter that based on 3 columns ( the filter must be a single value and offer ID cant be duplicated ) here is a little example and if can anyone can try it w...
Need Help
Show and Tell
v-joesh-msft's avatar
v-joesh-msft
Solution Sage
6 years ago

Hi Anonymous ,

As mentioned by JarroVGIT , I think the easiest way is to apply Unpivot Columns, and then use the count function to achieve the result you want:

Here is a demo, please try it:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EYcAU6C2hcdAqxZRIS2is1QBdfgFNkiGNYdFx_vwuWcb_g?e=wBvDnH

Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.