Urgent Help on Matrix

Question

Hello,&nbsp;I have 14 tables they are individual KPI tables with date,country and Actual values. Additionally i have created 3 tables one for Date,country and Target.&nbsp;I am creating a Matrix visual. I am able to get categories and sub categories and metrics as an hierarchy in rows. Target is added separately in values. However when i add Actuals it is actually getting added as a separate columns. Please tell how i could add the average correctly.&nbsp;&nbsp;Example:&nbsp;&nbsp;Category&nbsp; &nbsp;Sub-cat&nbsp; Actual&nbsp; TargetA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; aa&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 55&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; bb&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 60&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp;I want it in above format but it is coming in below format&nbsp;&nbsp;Category&nbsp; &nbsp;Sub-cat&nbsp; Actual&nbsp; Actual TargetA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; aa&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 55&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; bb&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 60&nbsp; &nbsp; &nbsp; 100&nbsp;Please help

pauldbrown · Answer

Anonymous&nbsp;What is the structure of your tables?

anonymous · Answer

I have 14 Indivual KPI tables with Metric name, country, date, Actual value.

I have created 3 tables Country, Date, Target

Country table links to kpi tables on country.
date table links to kpi tables on date.
Target Table links to Kpi tables on Metric name.

pauldbrown · Answer

Anonymous&nbsp;it is going to be difficult to help solve the problem without seeing a sample of your tables (with false data if need be).are the sum of actuals in your matrix summing up values form different columns?

anonymous · Answer

I can pm you the pbi file.

Forum Discussion

Urgent Help on Matrix

4 Replies

Related content

Urgent question about Policy update

Matrix table

urgent help needed

Need Urgent Help on SamePeriodLastYear

Urgent Help - Power Query - Data Transformation