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

Anonymous's avatar
Anonymous
Not applicable
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.