cancel
Showing results for
Did you mean:

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

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 PosMin Normal Max Normal
 LABELLASTIC 350ML DASANI
Label27010000000180270180-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

Status: New
Moderator

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

Member

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

Member

@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 ?

Member

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

not really know the trick to exchange this.

Moderator

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

Member

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 PosMin Normal Max Normal
 LABEL PLASTIC 350ML DASANI
Label27010000000180270180-1000000000
Member

@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 ?

Completed Ideas

Idea Statuses