I need to group data by version.

[Anonymous]

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.

[Samarth_18]

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

[Anonymous]

If i want to filter the measure to get data only for com.microsoft.andriod and com.microsoft.powerpoint.

how to do it.

[Samarth_18 · Accepted 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