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.

     

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.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 months ago

    Hi NameTaken,
    Hope the information provided helps resolve your issue. If you have any further questions or need additional assistance, please don’t hesitate to contact us. We are always happy to help.

    Regards,
    Community Support Team.