Forum Discussion

Josef's avatar
Josef
Icon for Helper I rankHelper I
6 years ago

Measure with replacing blank with 0 does not respect applied slicers/filers

Hi,   I'm working on a Power BI template for a wind farm company and I ran into some problems with a measure not respecting the applied slicers.   On my report I applied the next three slicers to...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
Josef
Icon for Helper I rankHelper I
6 years ago

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 🙂