Forum Discussion
Solved
how to use calculate function with multiple filters ?
how to make a MEASURE in which pass multiple filters in calculate function.
because below MEASURE is not working with multiple filter only work with single filter.
Not working
--------------
Measure =
CALCULATE(
COUNTA('EPU'[Project Status]),
FILTER('EPU','EPU'[Project Status]="Delayed"),
FILTER(ALL(EPU),'EPU'[Project Status]="On Schedule")
)
Working
------------
Measure =
CALCULATE(
COUNTA('EPU'[Project Status]),
FILTER('EPU','EPU'[Project Status]="Delayed"),
)
Try with following
Measure = CALCULATE ( COUNTA ( 'EPU'[Project Status] ), FILTER ( 'EPU', 'EPU'[Project Status] IN { "Delayed", "On Schedule" } ) )
3 Replies
- Zubair_Muhammad
Community Champion
Try with following
Measure = CALCULATE ( COUNTA ( 'EPU'[Project Status] ), FILTER ( 'EPU', 'EPU'[Project Status] IN { "Delayed", "On Schedule" } ) )I am applying this on PIE chart and want to break the pie with different colors and different values. but it is sum all values and show total as one in pie chart. but i want another one (second one).
showing below.
Required
- Zubair_Muhammad
