Forum Discussion

vividarinda's avatar
vividarinda
Icon for Helper II rankHelper II
2 years ago
Solved

Flag 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...
data protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi vividarinda 

 

I can't understand the logic completely.

Why the Ex0208 is 17.3 and 103?

 

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's avatar
vividarinda
Icon for Helper II rankHelper II
2 years ago

hi 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      vividarinda
      Icon for Helper II rankHelper II
      2 years ago

      Hi Anonymous ,

      Thank you so much for the reply and solution. Amazing !