Forum Discussion

Frequent Visitor

8 years ago

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 --------------...

Need Help

Zubair_Muhammad

8 years ago

basim

Try with following

Measure =
CALCULATE (
    COUNTA ( 'EPU'[Project Status] ),
    FILTER ( 'EPU', 'EPU'[Project Status] IN { "Delayed", "On Schedule" } )
)

Zubair_Muhammad
8 years ago
basim

You should put the Status Field in "Legend:

And "Countof Project Status" in "VALUES"

basim

Frequent Visitor

8 years ago

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