Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am needing to calcualte the Max Value for a data set that has multiple categories to sort through. The Max value needs to be the Max value of each ProductRef within each SubCatName. My current calcuated column is only giving me the Max value based on the ProdectRef and ignoring the SubCatName.
Current Measure:
@Anonymous Try:
New Measure:
MaxValue =
VAR __SubCatName = MAX('robintable'[SubCatName])
VAR __ProductRef = MAX('robintable'[ProductRef])
RETURN
MAXX(FILTER(ALLSELECTED('robintable'),[SubCatName]=__SubCatName && [ProductRef] = __ProductRef),[ConvertedPrice])
or if you don't care about the productref:
MaxValue =
VAR __SubCatName = MAX('robintable'[SubCatName])
RETURN
MAXX(FILTER(ALLSELECTED('robintable'),[ProductRef] = __ProductRef),[ConvertedPrice])
My original dax of
MaxValue = VAR maxvalue = CALCULATE(MAX(robintable[ConvertedPrice]), ALLEXCEPT(robintable, robintable[SubCatName], robintable[ProductRef])) return maxvalue
is giving me the max value of each SubCatName and not the max value of the ProdcutRef within each SusCatName
Hi @Anonymous ,
Basically the measure formula written by you should work.
Measure =
CALCULATE(
MAX('robintable'[ConvertedPrice]),
ALLEXCEPT(
robintable,
'robintable'[SubCatName],
robintable[ProductRef]
)
)
Perhaps you can check whether you have applied any other visual filters or page filters in the report.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I tried both of those options, and neither worked. Have any other ideas? I need it to look at each SubCatName and then the ProductRef with in that SubCatName and give me the Max value for all dates
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |