Flag The Data and Show Max Min with Other Column

[vividarinda]

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 visualization historical based on table logic.

[amitchandak]

@vividarinda ,The information you have provided is not making the problem clear to me. Can you please explain with an example. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Appreciate your Kudos.

[vividarinda]

Hi @amitchandak ,

I updated visualization visualization 

[Anonymous]

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]

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 · Accepted solution]

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 !

[vividarinda]

Hi @amitchandak ,

This link : visualization.pbix

The expected result refer from Raw Data Table and Logic Table. If value from on Raw Data Table min or max from threshold on Logic Table, then show the visualization.