Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello Team,
What is the error in the below image?
Also Table 'data' has a column as 'user.
Measure:
Thanks,
Siva
Solved! Go to Solution.
@ssspk try this
UniqueUsersPerAppIdTest = VAR FilteredData =
FILTER( data,
('data'[type] = 4 || 'data'[type] = 6) && 'data'[appid] > 0 )
RETURN
SUMX(
SUMMARIZE(
FilteredData,
'data'[appid],
"Unique Users", CALCULATE(COUNTROWS(DISTINCT('data'[user]))) ), [Unique Users] )
@ssspk try this
UniqueUsersPerAppIdTest = VAR FilteredData =
FILTER( data,
('data'[type] = 4 || 'data'[type] = 6) && 'data'[appid] > 0 )
RETURN
SUMX(
SUMMARIZE(
FilteredData,
'data'[appid],
"Unique Users", CALCULATE(COUNTROWS(DISTINCT('data'[user]))) ), [Unique Users] )
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |