Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Using ALLEXCEPT and/or ALLSELECTED to ignore multiple active slicers except for 2 slicers/columns

Hello,    I have a report that contains 1 table in the data model: "EncounterFact". It has 2 measures:   1)  Providers (ALLEXCEPT 2) = CALCULATE ( CALCULATE (EncounterFact[Providers], ALLEXCEPT...
ALLEXCEPT
ALLSELECTED
Anonymous's avatar
Anonymous
Not applicable
6 years ago

stevedep I tried this revised one and I get the results below in the Matrix photo. Somehow the total needs to be at the row level, but I get these various row totals. Unfortunately I can't share many details with the data since it's healthcare, but I attached a second photo showing the single table I have in the data model.

 

I appreciate your continued help.

 

Matrix

Data Model

stevedep's avatar
stevedep
Icon for Memorable Member rankMemorable Member
6 years ago

The best way to get desired result is to create dimension table and a date table and then join these with your fact table. Most issues on the forum have as root cause a sub optimal data model.