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.
Community ChampionAre both relationships one-to-many SINGLE direction from the dim table to the fact table?
I have the following relationship
Dim 1 : n Fact (single)
Dummy Dim 1 : n Fact (single)
I thought filtering on my Dim would never impact the records of my Dummy dim, because the filtering goes from Dummy Dim to Fact and not the other way around.
However I guess the Dim table does filter the fact table, to just one or a few records. And I suppose that Power BI only shows the Dummy Dim records for which there is a fact....
That is not what I expected after reading the article of Phil_Seamark : https://dax.tips/2020/02/05/overriding-slicers/
Somehow filtering on his original date table, doesn't affect anything on the dates of his dummy table.
I just want to understand how this works and replicate the gist of the article.
So this is NOT about interactions. 🙂