Forum Discussion
Overriding slicers
Hi JWA___ ,
When you select a value (e.g. "dim 1"), the measure will only return 105 for the "dim 1" row, and the other rows will be blank. At this point Power BI will hide the rows with blank values by default. You can check "Show items with no data" to show the hidden rows.
You can also change the measure to the following formula.
Measure 2 = CALCULATE(SUM('Fact Table'[Nr]), ALL('Dim Table'))If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi JWA___ ,
When you select a value (e.g. "dim 1"), the measure will only return 105 for the "dim 1" row, and the other rows will be blank. At this point Power BI will hide the rows with blank values by default. You can check "Show items with no data" to show the hidden rows.
You can also change the measure to the following formula.
Measure 2 = CALCULATE(SUM('Fact Table'[Nr]), ALL('Dim Table'))
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, this does make sense. I thought of this last weekend, but this articulates it clearly, thank you.
