Forum Discussion
Need help with the dax
Hi Avivek ,
According to your statement, I think your problem is that you want to remove the filter from slicer in your visual. As far as I know, if the column in slicer is from same table or from a related table, Power BI will filter your visual by context. Here I suggest you to create unrelated dim tables to build slicer. And you can use SELECTEDVALUE() to catch single value or use VALUES() to catch multiple values in your measure.
If this reply still couldn't help you solve your problem, please share a sample file without sensitive data with us. And show us a screenshot with the result you want. This will make it easier for me to find the solution.
Best Regards.
Hi Avivek ,
According to your statement, I think your problem is that you want to remove the filter from slicer in your visual. As far as I know, if the column in slicer is from same table or from a related table, Power BI will filter your visual by context. Here I suggest you to create unrelated dim tables to build slicer. And you can use SELECTEDVALUE() to catch single value or use VALUES() to catch multiple values in your measure.
If this reply still couldn't help you solve your problem, please share a sample file without sensitive data with us. And show us a screenshot with the result you want. This will make it easier for me to find the solution.
Best Regards.