Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi, I would like to find a way to visualize the percentage of each category from a column called Status, but I would like to use another column called ID as a reference for the total count of them (making sure there is a distinct count in the total of ID values) as the rows contain duplicates.
Both columns look like this:
Status ID
Approved M1
Approved M1
Rejected E2
Initiated F3
Initiated P6
Pending L4
Pending L4
Approved X9
Approved X9
Approved T8
Thanks for your help!
Solved! Go to Solution.
Hi,
Please check the below picturea and the attached pbix file.
Percentage measure: =
DIVIDE (
DISTINCTCOUNT ( Data[ID] ),
CALCULATE ( DISTINCTCOUNT ( Data[ID] ), REMOVEFILTERS () )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
Please check the below picturea and the attached pbix file.
Percentage measure: =
DIVIDE (
DISTINCTCOUNT ( Data[ID] ),
CALCULATE ( DISTINCTCOUNT ( Data[ID] ), REMOVEFILTERS () )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thanks a lot! it works perfect!