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.

     

Anonymous's avatar
Anonymous
Not applicable
10 months ago

Hi NameTaken,

I would also take a moment to thank grazitti_sapna  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Regards,
Community Support Team.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 months ago

    Hi NameTaken,
    I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.


    Regards,
    Community Support team.

    • NameTaken's avatar
      NameTaken
      Frequent Visitor
      10 months ago

      My apologies for not being able to get back to this sooner. 

      The solution seems to not work with the Created Date Slicer like the Purchase Count Total measure. 

      When using the Created Date the answer was no longer correct so I think I need to add something to keep that filter.
      However when I added: 

      KEEPFILTERS(VALUES('Volume'[CustomerGroupName])),
          'Volume'[CreatedDate] >= MIN('Volume'[CreatedDate]),
          'Volume'[CreatedDate] <= MAX('Volume'[CreatedDate])
      )
       
      the calculation no longer produces the correct answer at all. I need the reference label to respect the Created Date slicer like everything else on the page does. 
      • Anonymous's avatar
        Anonymous
        Not applicable
        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.