Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have two tables, I want to calculate percentage users using NumUsers from Table 1 and Totalusers from Table 2.
I want to show , Percentage users who performed an action based on the Platform and usertype combination . Platform and UserType will be slicers and the percentage has to change based on filters applied.
Example : Percentage of Users who clicked on "Subscribe" should be 10/10 (NumUsers from row 1 of table 1)/ (Chrome Paid TotalUsers) instead of 10/100 (Numusers from row1 of table1/ Totalusers across all platforms and usertypes).
I tried merging the platform and usertype columns to create a relationship between the two tables but that did not work as expected.
Table 1: UserActions
Action | Platform | UserType | NumUsers |
Subscribe | Chrome | Paid | 10 |
Subscribe | Edge | Free | 5 |
Click Help | Edge | Paid | 6 |
Click Help | Chrome | Free | 5 |
Click Help | FireFox | Free | 4 |
Click Help | FireFox | Paid | 4 |
Search | Edge | Free | 4 |
Search | Edge | Paid | 6 |
Search | Chrome | Free | 10 |
Table 2: Total Users
Platform | UserType | TotalUsers |
Chrome | Paid | 10 |
Chrome | Free | 20 |
Edge | Paid | 20 |
Edge | Free | 15 |
FireFox | Paid | 15 |
FireFox | Free | 20 |
Any help is appreciated.
@data_insights, see the data model below:
Create measure:
% Users =
VAR vNumUsers = SUM ( UserActions[NumUsers] )
VAR vTotalUsers = SUM ( TotalUsers[TotalUsers] )
RETURN
DIVIDE ( vNumUsers, vTotalUsers )
Result:
Proud to be a Super User!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
7 |
User | Count |
---|---|
14 | |
12 | |
11 | |
10 | |
9 |