Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

I need to group data by version.

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 list...
Need Help
  • Samarth_18's avatar
    Samarth_18
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
Samarth_18
Community Champion
5 years ago

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