Forum Discussion

NameTaken's avatar
NameTaken
Frequent Visitor
10 months ago
Solved

Reference Label as a percent

Hello,    I have Customer Groups and then Individual Customer as slicers in my report. I can currently take the entire customer portfolio, say its 100, and the amount of a Customer Group (call it ...
Need Help
  • Anonymous's avatar
    Anonymous
    10 months ago

    Hi NameTaken,

    I have reproduced your requirement and implemented the solution. I have attached the PBIX file for your review so you can see the updates. Let me know if you need any changes or further improvements.


    Regards,
    Community Support Team.

     

grazitti_sapna's avatar
grazitti_sapna
Icon for Super User rankSuper User
10 months ago

Hi NameTaken,

 

Firslty let's create a measure which reoves filters and counts total applications

 

PurchaseCount (Group) =
CALCULATE(
DISTINCTCOUNT('Volume'[Application_id]),
REMOVEFILTERS('Volume'[CustomerName]),
KEEPFILTERS(VALUES('Volume'[CustomerGroupName]))
)

Now create final % measure

 

PurchaseCount_Percent_Selected_Customer =
DIVIDE(
[PurchaseCount_Selected_Customer],
[PurchaseCount (Group)],
0
)🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!