Multiple Measures need to show a table visual

[basirve]

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

[v-henryk-mstf]

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.

[amitchandak · Accepted solution]

@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])
)