Forum Discussion
Solved
filter from different column
Hi, I use the "Slicer" column for a slicer to select. I also use the month column as a slicer. I try to write a measure that should give me the following result: If nothing is selected in the sli...
- Value total : =IF (NOT ISFILTERED ( Slicer[Slicer] ),CALCULATE ( SUM ( Data[Value] ), KEEPFILTERS ( Types[Type] = "V" ) ),SUM ( Data[Value] ))
Value total : =
IF (
NOT ISFILTERED ( Slicer[Slicer] ),
CALCULATE ( SUM ( Data[Value] ), KEEPFILTERS ( Types[Type] = "V" ) ),
SUM ( Data[Value] )
)