Forum Discussion

RitaMunha's avatar
RitaMunha
Icon for Helper I rankHelper I
6 years ago
Solved

Create relation between measure and table - use slicers

 

Hi everyone,

Need help!

I´m dealing with a problem with my dashboard. It seems that i`m not able to filter my list of users based on a scale slicer and i can`t even see in my doughnut graph wich users are included in certain scale

Context:

I needed to calculate the average of points by user and determine the corresponding level (based on a scale) taking into account the start date and end date, that is, the average had to vary dynamically according to the defined interval. For this I used 2 measures:

 
Average points = AVERAGE(Data[Points])
 
COunt = COUNTROWS(FILTER(ADDCOLUMNS(VALUES(Data[User]);"ABCD";CALCULATE([Average points];CALCULATETABLE(VALUES(Data[User]));ALLSELECTED()));COUNTROWS(FILTER(Segments;[ABCD]>=Segments[Lower limit]&&[ABCD]<=Segments[Upper limit]))>0))+0

 

With this i was i able to create de doughnut graph. The problem is:

1) i want to use a slicer that filter de doughnut and the list of users, but i but I don't know how to create this relationship while maintaining the dynamic model

2) I also need to be able to see wich users are in certain scale, selecting part of the doughnut graph

I`ve attached a file to simplify the understanding.

here

 

Thanks in advance

  • Hi RitaMunha 

     

    Actually the only change that you need is adding your COunt Measure, as a Visual filter, please see the below.

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn



     

3 Replies

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion

    Hi RitaMunha 

     

    Actually the only change that you need is adding your COunt Measure, as a Visual filter, please see the below.

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn



     

    • RitaMunha's avatar
      RitaMunha
      Icon for Helper I rankHelper I

      Thank you so much Mariusz !! I still have too much to learn... :S

       

      Could you suggest some online courses? 

       

      thanks again! Be safe 🙂