Forum Discussion
Solved
Comparing count values with and without filters
Hi All, I am trying to compare the total count difference of policies per company with AND without the slicer. Here is a simple example of my scenario: Compnay Name Policy Number Fil...
Policies by company = DIVIDE( DISTINCTCOUNT(MyTable[PolicyNumber]) , CALCULATE( DISTINCTCOUNT(MyTable[PolicyNumber]), ALL(MyTable[Filter X]), ALL(MyTable[Filter Y])))
The numerator applies the whole filter context, the denominator replaces Filter X and Filter Y with all the values for both.
Policies by company = DIVIDE( DISTINCTCOUNT(MyTable[PolicyNumber]) , CALCULATE( DISTINCTCOUNT(MyTable[PolicyNumber]), ALL(MyTable[Filter X]), ALL(MyTable[Filter Y])))
The numerator applies the whole filter context, the denominator replaces Filter X and Filter Y with all the values for both.