Forum Discussion
Helper IMeasure with replacing blank with 0 does not respect applied slicers/filers
Community SupportHi Josef ,
Can you please share a dummy pbix file and upload to OneDrive for Business? If you can't do that, please share some sample data and expected results. We will understand more clearly.
Helper IHi v-xuding-msft,
Yes sure, I created a dummy pbix and uploaded it to OneDrive for Business.
You can download it here.
There are 2 pages in the file, one with the slicers and one with the sample visualization.
The slicers are synced to the page with the visualization.
Also I created a screen recording gif to show what is the problem.
Many thanks in advance for your help!
- v-xuding-msft
Hi Josef ,
Sorry for late back.
I test the dummy file. It is caused by the logic of DAX Query and the filter order. For your scenario, I'm think you could try to remove Turbines[Turbine] and change it to Tubine Data [Turbine] in the matrix.
- Josef
v-xuding-msft many thanks for your reply!
Your solution is working perfectly, so thank a lot for that.
However in my final scenario it's unfortunatly not possible to use the other column. This is because in my final scenario I have to display extra columns from the Turbine table.
Do you perhaps know another solution, keeping the original column?
Even after watching the video 'Deep dive into DAX evaluation context' by SQLBI I still don't understand why PowerBI is igonoring the applied filters.
Hope you can help 🙂