Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

 

1.PNG2.PNG4.PNG5.PNG

 

 

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 PosMin Normal Max Normal
Concentrate Coca-Cola Part 1Concentrate-1000000006060808010000000000

 

* and I have Label condition is : 

Description Categories Min High Risk Max High Risk Min Pos Max PosMin Normal Max Normal
LABEL:PLASTIC 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
Comments
v-qiuyu-msft
Community Support

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
Post Prodigy

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

Chanleakna123
Post Prodigy

@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
Post Prodigy

@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
Community Support

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". 

 

q4.PNG

 

 

Best Regards,
Qiuyun Yu

Chanleakna123
Post Prodigy

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
Chanleakna123
Post Prodigy

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