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

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
5 years ago

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'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
    Icon for Community Champion rankCommunity 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