Forum Discussion
Mann
Resolver III
Resolver IIIFinding Max of a column value as per groups dynamically when user selects Slicer on DateTime
Hi All, I have one interesting scenario and I am kind of struggling to find a fix for it. There is a table which has "Parent", "Child", "DateTime", "Value" field as shown: I need to do tw...
Hi Mann,
According to your description, my understanding is that you want to find the max data for each group of parent based on the selected DateTime.
In this scenario, we can use the following measure:
MaxValue = CALCULATE(MAX(Data[Value]),FILTER(ALLSELECTED(Data),Data[Parent] = MIN(Data[Parent])))
The result will like below:
Best Regards,
Teige
TeigeGao
Solution Sage
Solution SageHi Mann,
According to your description, my understanding is that you want to find the max data for each group of parent based on the selected DateTime.
In this scenario, we can use the following measure:
MaxValue = CALCULATE(MAX(Data[Value]),FILTER(ALLSELECTED(Data),Data[Parent] = MIN(Data[Parent])))
The result will like below:
Best Regards,
Teige
MannResolver III
Resolver IIIThanks TeigeGao!!
It worked as expected.
It worked as expected.