Forum Discussion
SharePoint list Calculation
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.
1 Reply
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.
