Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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] )