Forum Discussion

BossCo's avatar
BossCo
Icon for Helper II rankHelper II
5 years ago
Solved

ALLSELECTED 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

 

IDNo. of Date YesNo. of Date NoNo. of Null Dates
1672211
29811
310000
405545
5801010

 

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:

 

IDNo. of Date YesNo. of Date NoNo. of Null Dates
100100
200100
300100
405545
5801010

 

How can I work it out?

 

Thanks!

3 Replies

    • BossCo's avatar
      BossCo
      Icon for Helper II rankHelper II

      Hi,

       

      it's in the dimension table. I also tried to use the one in my fact table but it doesn't change anything

    • BossCo's avatar
      BossCo
      Icon for Helper II rankHelper II

      Ok ok ok, I used the one in my GROUP dimension table and now it works. Thanks a lot!