Forum Discussion
vividarinda
Helper II
Helper IIFlag The Data and Show Max Min with Other Column
Hi All, I have the data like this : table historical -> table logic -> the visualization like this : but expected result like this : i want to show the visu...
Hi vividarinda
Here I create 2 measure:
BlowbuPress = VAR _currentUnitno = SELECTEDVALUE ( 'raw data'[unitno] ) RETURN CALCULATE ( MAX ( 'raw data'[blowbypress_max] ), FILTER ( ALLSELECTED ( 'raw data' ), 'raw data'[unitno] = _currentUnitno ) )Boost_press = VAR _currentUnitno = SELECTEDVALUE ( 'raw data'[unitno] ) RETURN CALCULATE ( MIN ( 'raw data'[boost_press_max] ), FILTER ( ALLSELECTED ( 'raw data' ), 'raw data'[unitno] = _currentUnitno ) )The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
vividarindaHelper II
Helper IIhi Anonymous ,
Thanks for your reply
results obtained from it :
1. field flagging from raw data table is 1 and
2. value blowbypress_max in raw data if compare in logic table, get max value
and value bosstpress_max in raw data if compare in logic table, get min value
Hi vividarinda
Here I create 2 measure:
BlowbuPress =
VAR _currentUnitno =
SELECTEDVALUE ( 'raw data'[unitno] )
RETURN
CALCULATE (
MAX ( 'raw data'[blowbypress_max] ),
FILTER ( ALLSELECTED ( 'raw data' ), 'raw data'[unitno] = _currentUnitno )
)
Boost_press =
VAR _currentUnitno =
SELECTEDVALUE ( 'raw data'[unitno] )
RETURN
CALCULATE (
MIN ( 'raw data'[boost_press_max] ),
FILTER ( ALLSELECTED ( 'raw data' ), 'raw data'[unitno] = _currentUnitno )
)
The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- vividarinda
Hi Anonymous ,
Thank you so much for the reply and solution. Amazing !