Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!!!