Generic Column based on other columns in Powerbi

Hi shubh_kush ,

You can create a seperate table for unique benefits as below

Table 2 =
VAR distnct_benefit1 =
    DISTINCT ( Deployment[Benefit 1] )
VAR distnct_benefit2 =
    DISTINCT ( Deployment[Benefit 2] )
VAR distnct_benefit3 =
    DISTINCT ( Deployment[Benefit 3] )
RETURN
    DISTINCT ( UNION ( distnct_benefit1, distnct_benefit2, distnct_benefit3 ) )

Now create a two measure one for onprem and another for cloud with below code

Cloud =
VAR result =
    CALCULATE (
        COUNT ( Deployment[Deployement] ),
        FILTER (
            Deployment,
            Deployment[Deployement] = "Cloud"
                && (
                    Deployment[Benefit 1] = MAX ( 'Table 2'[Benefits] )
                        || Deployment[Benefit 2] = MAX ( 'Table 2'[Benefits] )
                        || Deployment[Benefit 3] = MAX ( 'Table 2'[Benefits] )
                )
        )
    )
RETURN
    IF ( ISBLANK ( result ), 0, result )

On_Prem =
VAR result =
    CALCULATE (
        COUNT ( Deployment[Deployement] ),
        FILTER (
            Deployment,
            Deployment[Deployement] = "On Prem"
                && (
                    Deployment[Benefit 1] = MAX ( 'Table 2'[Benefits] )
                        || Deployment[Benefit 2] = MAX ( 'Table 2'[Benefits] )
                        || Deployment[Benefit 3] = MAX ( 'Table 2'[Benefits] )
                )
        )
    )
RETURN
    IF ( ISBLANK ( result ), 0, result )

Now add benefits column from newly created table and add above measure you will see required output as below

Thanks,

Samarth