Forum Discussion
Solved
Dynamic Text Box based on 2 slicers
Hello, I have 2 slicers and the I want the result text box in such a way that if I select the first slicer and don't select any option from the second slicer, the text should be based on only the se...
Something like this should work:
Text Measure = VAR varFirstSlicer = SELECTEDVALUE( Table[Field] ) VAR varSecondSlicer = SELECTEDVALUE( Table[Field2] ) VAR Result = IF( ISBLANK( varSecondSlicer ), varFirstSlicer, varSecondSlicer ) RETURN ResultIf the second slicer has anything but 1 value selected, you'll get the first slicer value.
