Forum Discussion
One vs Rest
Hi pradeept ,
Please follow these steps:
1. Create a table for X-axis by entering data like this:
2. Just need one measure:
Expected output = var _curr=CALCULATE(SUM('Table'[Rating]),ALLEXCEPT('Table','Table'[Department])) var _rest=CALCULATE(AVERAGE('Table'[Rating]),FILTER(ALL('Table'),'Table'[Department]<>MAX('Table'[Department]))) return IF(MAX('X-axis'[Type])="Rest",_rest,IF(MAX('Table'[Department]) =MAX('X-axis'[Type]),_curr))The final output is shown below:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi pradeept ,
Please follow these steps:
1. Create a table for X-axis by entering data like this:
2. Just need one measure:
Expected output =
var _curr=CALCULATE(SUM('Table'[Rating]),ALLEXCEPT('Table','Table'[Department]))
var _rest=CALCULATE(AVERAGE('Table'[Rating]),FILTER(ALL('Table'),'Table'[Department]<>MAX('Table'[Department])))
return IF(MAX('X-axis'[Type])="Rest",_rest,IF(MAX('Table'[Department]) =MAX('X-axis'[Type]),_curr))The final output is shown below:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous this is the solution I am looking for. Thank you so much for your time.👏👏
I tweaked the measure little bit, for the other filters interactivity and working fine. Now I have to create 8 charts and apply the department as visual level filter.