Calculate percentages dynamically when filters are applied

data_insights — Wed, 10 Jun 2020 22:21:03 GMT

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.

Re: Calculate percentages dynamically when filters are applied

DataInsights — Sat, 05 Sep 2020 21:42:06 GMT

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:

topic Calculate percentages dynamically when filters are applied in DAX Commands and Tips

Calculate percentages dynamically when filters are applied

Re: Calculate percentages dynamically when filters are applied