Forum Discussion

gvialetto_kv's avatar
gvialetto_kv
Regular Visitor
6 years ago
Solved

Different KPIs on the same table

Dear community,

I recently faced this problem and I would like to discuss the easier way to manage it. Here I attach the example


Data are defined in Table1, each row is unique and each row has a type. I need to define on the dashboard on a table different KPIs on row and each KPI is defined differently (see Table 2).

Does anyone have useful suggestion to perform it on PowerBI?

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    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/

     

     

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    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/