Forum Discussion

basirve's avatar
basirve
Icon for Helper III rankHelper III
5 years ago
Solved

Multiple Measures need to show a table visual

 

Dear Expers,

I have table1 contains the cliumns (ReportsToName,AgentName,Tier), Metrics are defined from different measure from different tables, So i would like to bring all measure into one table visual, kindly help me to achive the requirment.

 

 

Thnaks & Regards,

Venkat

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    basirve , you have to create a table like

     

    new Table =
    union(
    summarize('Table','Table'[ReportsToName], 'Table'[AgentName], 'Table'[Tier],"Measure", "AHT", "Score", [AHT Score], "Target" ,[AHT Target]),
    summarize('Table','Table'[ReportsToName], 'Table'[AgentName], 'Table'[Tier],"Measure", "NPS", "Score", [NPS Score], "Target" ,[NPS Target])
    )

2 Replies

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

    basirve , you have to create a table like

     

    new Table =
    union(
    summarize('Table','Table'[ReportsToName], 'Table'[AgentName], 'Table'[Tier],"Measure", "AHT", "Score", [AHT Score], "Target" ,[AHT Target]),
    summarize('Table','Table'[ReportsToName], 'Table'[AgentName], 'Table'[Tier],"Measure", "NPS", "Score", [NPS Score], "Target" ,[NPS Target])
    )

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi basirve ,

     

    According to your question. You want to integrate multiple measures you created in the same column, but I don’t know what the calculation logic of each individual measure is. Does it return a dynamic value or a static value?

    I want a method to try first:

    if (column1 = "Ram" && column2 = "Andy" && column3 = "Consultant", [measure1],0)
    if (column1 = "Ram" && column2 = "Andy" && column3 = "Consultant", [measure2],0)

     

    If it still can't help you solve the problem, I don't know if you can provide pbix file and detailed information. So that I can help you do further testing and solve your problem.

     

    Let me know immediately and looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.