!!!!!!Condition Calculation Error , Seeking Support

[Chanleakna123]

Hi team , 

My purpose is to have condition of High Risk , POS , Normal. 

* I have different Categories : Label and Concentrate in the same table. 
* You can see the Contrate conditin is 

Description	Categories	Min High Risk	Max High Risk	Min Pos	Max Pos	Min Normal	Max Normal
Concentrate Coca-Cola Part 1	Concentrate	-100000000	60	60	80	80	10000000000

* and I have Label condition is : 

Description	Categories	Min High Risk	Max High Risk	Min Pos	Max Pos	Min Normal	Max Normal
LABEL:PLASTIC 350ML DASANI	Label	270	10000000	180	270	180	-1000000000

*These 2 categories will be in the same table up and down. 

So i use the condition Calculation as per above. But the result is not meet my expectation. 

there're blank on the result. Look like the calculation were wrong and not meet. 

is there any one know the best practice of such different condition ? Can you tell me how ?
Your guidance is much appreciated. 

Thanks with Regards, 
Chanleakna Hang 

[v-qiuyu-msft]

Hi @Chanleakna123,

It's due to the logic of your DAX Total Status, the meaning of your formula is below: 

High Risk:  Min High Risk<= Total Day in <= Max High Risk
POS:          Min Pos< Total Day in <=Max Pos
Normal:     Min Normal< Total Day in <=Max Normal

Blank:       Total Day in< Min High Risk,

                  Total Day in> Max High Risk,

                  Total Day in<= Min Pos,

                  Total Day in > Max Pos,

                  Total Day in <=Min Normal,

                  Total Day in> Max Normal

You need to specify which results should be returned if it meets Blank condition. Otherwise, if there are values meet the blank condition, it will return blank values. 

Best Regards,
Qiuyun Yu 

[Chanleakna123]

@v-qiuyu-msft so what condition sign should i put there to meet my expectation ? i feel distracted here 😞 

[Chanleakna123]

@v-qiuyu-msfti dun want the condition turn to blank , i want it to calcuated in the condition as other, as i set. so what should i put the number there ? 

[Chanleakna123]

@v-qiuyu-msft I tried multiple ways to exchange the number still the result shown blank , 

not really know the trick to exchange this. 

[v-qiuyu-msft]

Hi @Chanleakna123,

When there are [Total Day in] values meet the condition below, which result do you want to return? 

Total Day in< Min High Risk,

Total Day in> Max High Risk,

Total Day in<= Min Pos,

Total Day in > Max Pos,

Total Day in <=Min Normal,

Total Day in> Max Normal

If you would like to return eg: "others", you can add below snippet to DAX. These blank values will be replaced as "others". 

Best Regards,
Qiuyun Yu

[Chanleakna123]

hi @v-qiuyu-msft i dun wnat to put others in this condtion. 

my purpose is to get all of those calculated to be in either HIgh Risk , or POS or Normal. 
acutally i just fill like my Condition that i set is right. 

if the Label between 270 to 10000000 day it will show High Risk. 
if the label between 280 to 270 day it will POS 

if label between 180 to -1000000000 it will show normal. 

and i set the condition in calculation matched with the concentrate. but most of the blank data is in Label , 

but my purpose is not to get this blank , they should either in one of them ( either high risk , POS or Normal ).

Description	Categories	Min High Risk	Max High Risk	Min Pos	Max Pos	Min Normal	Max Normal
LABEL PLASTIC 350ML DASANI	Label	270	10000000	180	270	180	-1000000000

[Chanleakna123]

@v-qiuyu-msft my question is , why Preform : -470 days are in Blank ? It should be Normal. 

i have no idea how to exchange the number in the condition table , would you mind to help me out ?