Forum Discussion
Mutliple Filters in same column
Hello All,
I am trying to calculate sum in column A depending on the multiple values in column B. To illustrate below is an example
Column A Column B
100 C1
200 D1
300 AB1
I am trying to calculate sum in column A only for values "C1" & "D1" but i am not able to do it.
Below is the formula i am writing but is there any way i can put multilple filter in there
Modify your measure as below:
NAV CY = CALCULATE ( SUM ( Table[Column A] ), FILTER ( Table, Table[Column B] = "C1" || Table[Column B] = "D1" ) )Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- NAV CY =
CALCULATE (
SUM ( [value] ),
FILTER ( table, table[columnname] = "C1" || table[columnname] = "DW" )
) Sandeep_rai , Try like
Measure =CALCULATE ( SUM ( Table[Column A] ), FILTER ( Table, Table[Column B] in { "C1" , "D1" } ))
3 Replies
Modify your measure as below:
NAV CY = CALCULATE ( SUM ( Table[Column A] ), FILTER ( Table, Table[Column B] = "C1" || Table[Column B] = "D1" ) )Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- NAV CY =
CALCULATE (
SUM ( [value] ),
FILTER ( table, table[columnname] = "C1" || table[columnname] = "DW" )
) Sandeep_rai , Try like
Measure =CALCULATE ( SUM ( Table[Column A] ), FILTER ( Table, Table[Column B] in { "C1" , "D1" } ))