Forum Discussion
Filter Multiple Columns for multiple filter options to create a Measure
CombineMeasure = CALCULATE(COUNT(Table[COL1]),FILTER(Table,(Table[Col1]="Completed"))) -- > Works (For one column)
but I need to filter and combine with 3 other options of 2 other columns
Please may I know how ?
But I have Col1 - > 2 filters AND (Table[COL1] ="Yes", Table[COL1] ="Not Sure")
Col2 -> AND(Table[Col2]="Yes", Table[Col2]<>"Not Sure", Table[Col2]="Parked")
Col3 -> AND(Table[Col3]="No", Table[Col3]<>"No Order ", Table[Col3]="New York")
Please may I know how to combine all above to create a measure to be used.
Thanks a ton
acerNZ ,
Two tbale values can not be and , they need Or or IN
example
CombineMeasure = CALCULATE(COUNT(Table[COL1]),FILTER(Table,(Table[Col1] in {"Yes", "Not Sure"})))
CombineMeasure = CALCULATE(COUNT(Table[COL1]),FILTER(Table,(Table[Col1] in {"Yes", "Not Sure"})))
1 or 2
CombineMeasure = CALCULATE(COUNT(Table[COL1]),FILTER(Table,(Table[Col1] in {"Yes", "Not Sure"}) || (Table[Col2]="Yes" || Table[Col2]<>"Not Sure" || Table[Col2]="Parked") ))
1 and 2
CombineMeasure = CALCULATE(COUNT(Table[COL1]),FILTER(Table,(Table[Col1] in {"Yes", "Not Sure"}) && (Table[Col2]="Yes" || Table[Col2]<>"Not Sure" || Table[Col2]="Parked") ))
add in this way
1 Reply
acerNZ ,
Two tbale values can not be and , they need Or or IN
example
CombineMeasure = CALCULATE(COUNT(Table[COL1]),FILTER(Table,(Table[Col1] in {"Yes", "Not Sure"})))
CombineMeasure = CALCULATE(COUNT(Table[COL1]),FILTER(Table,(Table[Col1] in {"Yes", "Not Sure"})))
1 or 2
CombineMeasure = CALCULATE(COUNT(Table[COL1]),FILTER(Table,(Table[Col1] in {"Yes", "Not Sure"}) || (Table[Col2]="Yes" || Table[Col2]<>"Not Sure" || Table[Col2]="Parked") ))
1 and 2
CombineMeasure = CALCULATE(COUNT(Table[COL1]),FILTER(Table,(Table[Col1] in {"Yes", "Not Sure"}) && (Table[Col2]="Yes" || Table[Col2]<>"Not Sure" || Table[Col2]="Parked") ))
add in this way