Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Does anyone know why every partner (FW Account Name (report name)-Partner) I select is giving the rank of 1 in my KPI?
Im using the formula : =aggr(rank({<[FW Account Name (report name)-Partner]>}(Scores)),[FW Account Name (report name)-Partner])
where 'scores' is a master measure
Scores:
@GeorgeEard
Try ignoring the selection:
{<YourSelection=>}aggr(rank({<[FW Account Name (report name)-Partner]>}(Scores)),[FW Account Name (report name)-Partner])
- Regards, Matheus
Thank you for the reply,
Do you mean add '{<YourSelection=>}' to the measure in the KPI?
If so I changed the measure in the KPI to {<YourSelection=>}aggr(rank({<[FW Account Name (report name)-Partner]>}(Scores)),[FW Account Name (report name)-Partner]) and the same issue is still occurring.
This YourSelection is an example, then you put the filter field example if your filter field is Customer then it stays:
{<Customer=>}