Forum Discussion
Solved
Overriding slicers
I have a very simple model: 1 dim table: My_dim dim1 dim2 dim3 dim15 1 fact table: Date My_dim Nr 1-1-2022 dim1 5 2-1-2022 dim2 20 1-1-2022 dim3 50 ...
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.
