Forum Discussion
BossCo
Helper II
5 years agoALLSELECTED and SLICER failure
Hi everybody! I got an issue I'm really struggling with.
Let's say I got an ID table, a Calendar table and a Fact table.
My fact table has "Id, Date, Yes/No" where the last one is a dicotomic variable.
My visual object composed by a date slicer, a GroupID slicer and the following table
| ID | No. of Date Yes | No. of Date No | No. of Null Dates |
| 1 | 67 | 22 | 11 |
| 2 | 98 | 1 | 1 |
| 3 | 100 | 0 | 0 |
| 4 | 0 | 55 | 45 |
| 5 | 80 | 10 | 10 |
And so on.
I calculated the No. of Null Dates like this:
CALCULATE(DISTINCTCOUNTNOBLANK(Calendar[Data]) - SUM([Date Yes]) - SUM([Date No]), ALLSELECTED(Calendar[Data]))
The problem is that the GROUP ID slicer doesn't work properly.
When I select, for instance, a group which includes ID's 4 and 5 here's the outcome:
| ID | No. of Date Yes | No. of Date No | No. of Null Dates |
| 1 | 0 | 0 | 100 |
| 2 | 0 | 0 | 100 |
| 3 | 0 | 0 | 100 |
| 4 | 0 | 55 | 45 |
| 5 | 80 | 10 | 10 |
How can I work it out?
Thanks!