Forum Discussion

New Member

3 years ago

Solved

statistics per tool per site

Hello, i would like to do a measure for the percentage of tool version that are in official version per site per tool i added a colum to get 1 if tool is official one and 0 if not and then i...

Need Help

v-easonf-msft

3 years ago

Hi, gilles13600

Please try formula like:

% =
VAR a =
    CALCULATE (
        DISTINCTCOUNT ( T_SOFT_REPOSITORY[Server] ),
        FILTER (
            T_SOFT_REPOSITORY,
            T_SOFT_REPOSITORY[__LAST_Tool1_EQUAL_OFFICIAL_Tool1] = 1
                && T_SOFT_REPOSITORY[Site] = "SITE1"
        )
    )
VAR b =
    CALCULATE (
        DISTINCTCOUNT ( T_SOFT_REPOSITORY[Server] ),
        FILTER ( T_SOFT_REPOSITORY, T_SOFT_REPOSITORY[Site] = "SITE1" )
    )
RETURN
    a / b

Best Regards,
Community Support Team _ Eason

statistics per tool per site.pbix33 KB

v-easonf-msft

Community Support

3 years ago

Hi, gilles13600

Please try formula like:

% =
VAR a =
    CALCULATE (
        DISTINCTCOUNT ( T_SOFT_REPOSITORY[Server] ),
        FILTER (
            T_SOFT_REPOSITORY,
            T_SOFT_REPOSITORY[__LAST_Tool1_EQUAL_OFFICIAL_Tool1] = 1
                && T_SOFT_REPOSITORY[Site] = "SITE1"
        )
    )
VAR b =
    CALCULATE (
        DISTINCTCOUNT ( T_SOFT_REPOSITORY[Server] ),
        FILTER ( T_SOFT_REPOSITORY, T_SOFT_REPOSITORY[Site] = "SITE1" )
    )
RETURN
    a / b

Best Regards,
Community Support Team _ Eason

statistics per tool per site.pbix33 KB