SharePoint list Calculation

[iDAXntKnow]

Hi All,

I am very new to PowerBI and DAX. I did a bit of SSRS reports, but I've been given a task and I don't know how to do it correctly. We have a SharePoint list (onprem), that contains TeamCode, location, salary, bonus, single or family etc. This information is written in a row, like:

TeamCode	Country1SingleTeamLeads	Country1FamilyVPs	Country1SingleTeamLeadRate	Country1FamilyVPRate	Country2SingleTeamLead	Country2FamilyVP	Country2SingleTeamLeadRate	Country2FamilyVPRate
1234A	0	2	15.00	20.00	0	3	15.00	20.00
4321B	1	0	15.00	20.00	1	2	15.00	20.00

What I need to do is a Matrix, Table of some sort in PowerBI that lists as:

Country1

1234A  |   SingleTeamLeads*SingleTeamLead Rate |   Total

1234A  |   FamilyVPs*FamilyVPRate

TOTAL

Country2

1234A  |   SingleTeamLeads*SingleTeamLead Rate |   Total

1234A  |   FamilyVPs*FamilyVPRate

TOTAL

Is it possible with the SP row? I've tried few methods, but the TeamCode column, and Country column stack, instead of next to each other. Tried creating a new table, create relationship teamcode, and I just can't get the result I need.

Any help is appreciated. If any videos are available, please link them too.

[v-yinliw-msft]

Hi @iDAXntKnow ,

You need to add a column or new a table that indicate the relationship between the country and the Teamcode, and if you want to add two columns side by side, you should add the column to the Value.

Like this:

You can refer this documentation to create a matrix:

Create a matrix visual in Power BI - Power BI | Microsoft Learn

Hope this helps you.

Best Regards,

Community Support Team _Yinliw

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