Forum Discussion
Resolver Ibased customer performance - provide rank diff b/w two months
Community Championvenug20 I didn't really get what you want with the slicer ? That means, if you select "Sep" in slicer then you want to show Sep and Aug. If you select "Aug" then you want to show Aug and Jul OR you need to show Aug and Sep (Just order of columns preference)...
Please elaborate a bit....
Resolver I
Yes, treat "Aug" & "Sep" as one table (Not Two tables). i want to show "Aug" & "Sep" months in "Slicer".
When i select "Sep", data shows for "Aug" & "Sep" months with rank customer wise.
When i select "Aug" data should be show for "Aug" & "July" months with rank customer wise. (This part, No need now, there is no data)
v-frfei-msftCommunity Support
Hi venug20,
I made one sample for your reference.
1. Create a calculated table using the formula and create retaltionship between it and teh fact table.
Table = DISTINCT(Table1[Customer])
2. Create the measures as below.Measure = SUM(Table1[Values])
rankall = RANKX(ALL('Table'),[Measure],,DESC,Dense)For more details, please check the pbix as attached. Please notice here we cannot meet the requirement as you said: "When i select "Sep", data shows for "Aug" & "Sep" months with rank customer wise." We can select slicer multi options to work around.
Regards,
Frank
- Ashish_Mathur
Super User
- venug20
Thanks for provide solution for this query, It's working fine as my point of view.
Thanks all who are respond to my query.
- Ashish_Mathur
You are welcome.