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 currently have a dataset that has rows similar to the below.
1/1/2020 5
1/1/2020 5
1/2/2020 8
1/2/2020 10
My matrix table sums those values together as displayed below:
1/1/2020 10
1/2/2020 18
I have to calculate the range for what is in the matrix not the dataset. From what I am gathering I cannot successfully tell PowerBI to find the MAX or MIN of a measure. I need something to find the MAX and MIN within the matrix not the dataset. If I use the below formula it will return a value of 5 not 10. Can anyone help with this?
This formula will give me the first number pulling the Highest value in the actual dataset. Is there anyway to tweak this to get the 10 that I need?
Solved! Go to Solution.
Hi @common763 ,
Please create a measure like this.
__Max_value =
VAR __table = SUMMARIZE( Sheet4, Sheet4[Date], "__Value", SUM(Sheet4[Value]) )
RETURN
MAXX(
__table,
[__Value]
)
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @common763 ,
Please create a measure like this.
__Max_value =
VAR __table = SUMMARIZE( Sheet4, Sheet4[Date], "__Value", SUM(Sheet4[Value]) )
RETURN
MAXX(
__table,
[__Value]
)
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This works. Accepting as a solution. Thanks for your help!!!
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 |
---|---|
16 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
26 | |
3 | |
2 | |
2 | |
2 |