calculate count values and percentage of count in one measure

[Anonymous]

I have a data like this..

.

Report is created on matrix visual like this...

Here i used a calcualtion for count values is 

countvalue = CALCULATE(DISTINCTCOUNT('Sheet1'[Policy]),'Sheet1'[ENDORSEMENT]=0 )

I need same calcualtion for count value with small changes ...The change is if category is Perecnatge of total then  calcualte percenatge values for count ...Ie..with in one column i want count calcualtion plus percenatge showing values...eg...

plse help...

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can create a measure as below:

countvalue = 
VAR _count =
    CALCULATE ( DISTINCTCOUNT ( 'Sheet1'[Policy] ), 'Sheet1'[ENDORSEMENT] = 0 )
VAR _percentage =
    DIVIDE (
        _count,
        CALCULATE (
            DISTINCTCOUNT ( 'Sheet1'[Policy] ),
            FILTER (
                ALLSELECTED ( 'Sheet1' ),
                'Sheet1'[Category] = SELECTEDVALUE ( 'Sheet1'[Category] )
                    && 'Sheet1'[ENDORSEMENT] = 0
            )
        ),
        0
    )
RETURN
    IF (
        SELECTEDVALUE ( 'Sheet1'[Category] ) = "Percentage of Total",
        FORMAT ( _percentage, "0%" ),
        _count
    )

Best Regards