Measure with multiple slicers applying (Beginner level) - example posted

Hi u92690 

I looked at your pbix file and made some changes, hoping that the result is what you want .

(1)I created three slicers by the fields from table “Territories” .Through the different levels to filter the data then to calculate the values .

(2)I created two relationships between three tables . Filter data from table “Territories” to table “Cases” and table “Tests” .

(3)Use the measure you created before ,and add a card visual to show the measure .

I have attached my pbix file, you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.