Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

AND Slicer

Hi all,   I have an AND slicer that I have picked up via various other posts on here, but wondered if it could be modified slightly. The DAX is:   AND Slice = VAR _EmptySlicer = NOT CALCULA...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Duh. 

     

    First of all, I had named one of my measures wrong - so it wasn't working. 

     

    Once I had fixed that, I then created a duplicate measure that addressed the [Head] skills, and then a third measure that compared the two and gave an outcome based on that evaluation.

     

    There's probably a more graceful way to do it, but this way worked. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Okay, I think the simplest way to look at this is my formula works too well at filtering things out.

 

 

AND Slice =
VAR _EmptySlicer =
NOT CALCULATE ( ISFILTERED ( Sheet1[Sub] ), ALLSELECTED ( Sheet1[Sub] ) )
RETURN
IF (
NOT ( _EmptySlicer ),
IF (
CALCULATE ( DISTINCTCOUNT ( Sheet1[Sub] ), ALLSELECTED ( Sheet1[Sub] ))
= COUNTROWS ( ALLSELECTED (Sheet1[Sub] ) ),
1
))
 
So, unless there is a [sub] selected then nothing is returned at all - which is GREAT! 
 
But... 
 
I would also like to have a result returned when a [head] is selected, I thought I could use something like an OR command (so IF [sub] OR [head], etc) that would cover it, but I think it's a level of DAX understanding that I don't quite have yet.
 
It may be a case of having it look at the [head] first, and then the [sub] and the issue is that I had originally built this based on the sub and then expanded from there (with various demands) so it could require a more through re-write. 
 
It would also be good to make it check other fields for inputs (I have a [note] field that it would be great for it to run a check on too) but I need to make sure I am keeping things within my limited knowledge! 
 
So, not sure if it is possible, but will keep on thinking.
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Duh. 

 

First of all, I had named one of my measures wrong - so it wasn't working. 

 

Once I had fixed that, I then created a duplicate measure that addressed the [Head] skills, and then a third measure that compared the two and gave an outcome based on that evaluation.

 

There's probably a more graceful way to do it, but this way worked.