Forum Discussion
Different KPIs on the same table
gvialetto_kv , Create new measures like
KPI 1 = divide(calculate(sum(table[value]),table[Type] ="A"),calculate(sum(table[value]),table[Type] ="B"))
KPI 2 = divide(calculate(sum(table[value]),table[Type] ="G"),calculate(sum(table[value]),table[Type] ="I"))
KPI 3 = divide(calculate(sum(table[value]),table[Type] ="H"),calculate(sum(table[value]),table[Type] ="E") - calculate(sum(table[value]),table[Type] ="F"))You can have a new table like given below
new Table=
union (summarize(Table, "KPI", "Value",[KPI 1] ,"KPI Def" , "A/B"),
summarize(Table, "KPI", "Value",[KPI 2] ,"KPI Def" , "H/I")
summarize(Table, "KPI", "Value",[KPI 3] ,"KPI Def" , "H/E-F"))Or Display in a Matrix with Show Values on Rows
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
gvialetto_kv , Create new measures like
KPI 1 = divide(calculate(sum(table[value]),table[Type] ="A"),calculate(sum(table[value]),table[Type] ="B"))
KPI 2 = divide(calculate(sum(table[value]),table[Type] ="G"),calculate(sum(table[value]),table[Type] ="I"))
KPI 3 = divide(calculate(sum(table[value]),table[Type] ="H"),calculate(sum(table[value]),table[Type] ="E") - calculate(sum(table[value]),table[Type] ="F"))
You can have a new table like given below
new Table=
union (summarize(Table, "KPI", "Value",[KPI 1] ,"KPI Def" , "A/B"),
summarize(Table, "KPI", "Value",[KPI 2] ,"KPI Def" , "H/I")
summarize(Table, "KPI", "Value",[KPI 3] ,"KPI Def" , "H/E-F"))
Or Display in a Matrix with Show Values on Rows
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
amitchandak thank you for your quick reply!
