Create relation between measure and table - use slicers

[RitaMunha]

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

[RitaMunha]

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

[Mariusz · Accepted solution]

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]

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

Could you suggest some online courses? 

thanks again! Be safe 🙂

[Mariusz]

Hi @RitaMunha 

This article explains how to do it

https://www.daxpatterns.com/dynamic-segmentation/

Best Regards,
Mariusz

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

Please feel free to connect with me.
LinkedIn