Forum Discussion
Difficulty Getting Denominator that uses ALLSELECTED Across Multiple Dimension Tables
Hello, I have an issue that I've been having difficulty with for a couple of months. I have one fact table (AGG_CASE_STATUS_DAILY) which is simply daily data on a Case_ID basis and several Dimens...
Hi Anonymous ,
In my understanding, your denominator metric may not be removing the specific dimension filter correctly when it is calculated, resulting in an error in the calculation, we can try using the RemoveFilters or ALL function instead of allselected to make sure that the filter's context is handled correctly.
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
Hope it helps!
Best regards,
Community Support Team_ Tom Shen
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.