Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Percentage for distinct count

I have a data like this..

 

.

Report is created on matrix visual like this...

Measure for countvalue is 

countvalue = CALCULATE(DISTINCTCOUNT('Sheet1'[Policy]),'Sheet1'[ENDORSEMENT]=0 )
I want (%) percentage value for category type Percenatge of Total based on count values ...
 
plse help...

 

Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try a mesure like

    countvalue % = divide(CALCULATE(DISTINCTCOUNT('Sheet1'[Policy]),filter('Sheet1','Sheet1'[ENDORSEMENT]=0 )),CALCULATE(DISTINCTCOUNT('Sheet1'[Policy]),filter(allselected('Sheet1'),'Sheet1'[ENDORSEMENT]=0 )))

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , Try a mesure like

    countvalue % = divide(CALCULATE(DISTINCTCOUNT('Sheet1'[Policy]),filter('Sheet1','Sheet1'[ENDORSEMENT]=0 )),CALCULATE(DISTINCTCOUNT('Sheet1'[Policy]),filter(allselected('Sheet1'),'Sheet1'[ENDORSEMENT]=0 )))