Forum Discussion

u92690's avatar
u92690
Frequent Visitor
5 years ago
Solved

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

Hey Friends,

 

I have a quiet simple issue, I guess, but im not getting to sort it out. I have two tabels, one with the cases and the other one with the tests, all of them broken down by administrative territory levels (Level 2 have several Level 3, but also several L2 can have just one Level 3) and data. I have created the measure cases/test, and i would like to get it calculated for the exact combinations of territory levels I select. However, I dont know how to do it for all the levels at the same time. Please, find below the example in which you'll see it so clearly.

 

PIBX -> https://drive.google.com/file/d/1ky3lIS8gjImwT5O4GJh3bheYkSMnMy5C/view?usp=sharing
Tables -> https://drive.google.com/file/d/1bKvRqhEv664ptYtmq3f6wPCfgpiCcqmG/view?usp=sharing

 

Thanks!!!

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

3 Replies