Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I am struggling for a few days with this issue. I have a table with 4 columns - SiteID, BrandID, Productgroup and Value. SiteID and ProductGroup are used as a slicer in the report and the visual is a table that shows BrandID and Sum(Value). I need 2 measures that would display the maximum and minimum of the Sum(Value) depending on the selection of the 2 slicers (taking in consideration also multiple selections on the slicers).
I've tried to create this measure, but the output is the maximum raw value (not summed):
Solved! Go to Solution.
I have figured it out. It was a simple update to the measure I was using. Can't believe I didn't try it until now :
Hi @Anonymous
It is not completely clear. Can you show an example based on data with the expected result, so as to further clarify what you need?
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs
Cheers
The table in the right is the raw table, SiteID and BrandID are not distinct values, each appear multiple times in the dataset.
The table in the left is the the visual where I need to display the Max and Min values. The Max value of the selected brands should be 4115, but instead my formula returns 1976.38.
Thank you,
Narcis
I have figured it out. It was a simple update to the measure I was using. Can't believe I didn't try it until now :
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
7 | |
6 |