Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I need to group data below in screen shot. i have two columns application and version columns in table.
here one applictaions have many versions and one version have many devices listed. I need outputs like application, version and Devices total count.
application ID | version | count |
commicrosoft.officeoutlookIOS | 4.3.1 (2915218) | 1000 |
commicrosoft.officeoutlookIOS | 4.2125.0 (9055108) | 150 |
commicrosoft.officeoutlookAndroid | 4.0.53 | 3000 |
commicrosoft.officeoutlookAndroid | 3.0.55 | 500 |
Here there are multiple versions and one versions have multiple devices connected. I need the count of devices for each version.
Solved! Go to Solution.
Hi @Anonymous ,
You can update your code with below.
Count_of_app_ver =
CALCULATE (
COUNTROWS ( version_data ),
FILTER (
version_data,
version_data[applicationversion] = MAX ( version_data[applicationversion] )
&& (version_data[mamapplicationid] in {"com.microsoft.andriod","com.microsoft.powerpoint" } )
)
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @Anonymous ,
You can create a measure with below code:-
Count_of_app_ver =
CALCULATE (
COUNTROWS ( version_data ),
FILTER (
version_data,
version_data[applicationversion] = MAX ( version_data[applicationversion] )
&& version_data[mamapplicationid] = MAX ( version_data[mamapplicationid] )
)
)
My data table:-
Output:-
Thanks
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
If i want to filter the measure to get data only for com.microsoft.andriod and com.microsoft.powerpoint.
how to do it.
Hi @Anonymous ,
You can update your code with below.
Count_of_app_ver =
CALCULATE (
COUNTROWS ( version_data ),
FILTER (
version_data,
version_data[applicationversion] = MAX ( version_data[applicationversion] )
&& (version_data[mamapplicationid] in {"com.microsoft.andriod","com.microsoft.powerpoint" } )
)
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |