Need to check how we can showcase values currently in Measure in Column in Matrix visual in Power BI

[Vaibhav05]

Hi,
I want to check how we can showcase the values stored in Measure in column in Matrix visual in Power BI report.

[Vaibhav05]

Hi @AmiraBedh 
I am trying to collate different KPI from Different sources together and would showcase the Values together on 1 Page. We need to Showcase Actuals in comparison with target values. The KPI Values (in the above Image) i..e Accidents: LTI or Accidents: TRI are coming from measure that we have built in their resp. imported files.
We are clubbing all KPI measures together and showcasing them in Matrix visual.
Need to check how we can showcase the values (Coming from Measure) together in 1 separate Column. which will look like the total col. (As highlighteded in the above image).

[Anonymous]

Hi  @Vaibhav05 ,

Let me try to reproduce your data and hopefully help you with your problem.

If you want to display values stored in metrics in a matrix visualobject, we can create a new table that includes the metrics to be displayed, and then build the dynamic metrics.

Measure 3 = SUM('Table'[Actual Value]) 

Measure 4 = SUM('Table'[Target])

Table 2 = DATATABLE("MeasureName",STRING,
"Sorting" ,INTEGER,
{
    {"Actual",1},
    {"Target",2}
}
)

Measure = SWITCH(SELECTEDVALUE('Table 2'[MeasureName]),
"Actual",[Measure 3],
"Target",[Measure 4],
BLANK())

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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

[Vaibhav05]

Hi @Anonymous ,
Thanks for your reply, I have checked but i want to Include the Total Actual and Total target column in the current matrix Visual which has KPIs. The solution presented was for Standalone visual however  when i am adding Actual or target column to current matrix then the table is not supporting because there is no relation between current table and new Table. Wanted to have the output as below:

[AmiraBedh]

Can you please share your model ?

[AmiraBedh]

Can you share some data ? your model ? the way you are implementing the measure?