Solved: Percentage for distinct count

NISHA_S · ‎05-05-2021

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...

amitchandak · ‎05-05-2021

@NISHA_S , 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 )))

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

amitchandak · ‎05-05-2021

@NISHA_S , 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 )))

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

Percentage for distinct count

Helpful resources

Power BI Monthly Update - October 2024

Microsoft Fabric & AI Learning Hackathon

Fabric Community Update - October 2024

How to Get Your Question Answered Quickly