Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Switch function not calculating total

Not sure if this is a duplicate post.  Submitted before but received an error and I don't see the post anywhere. Anyway, I have the following SWITCH funtion which gives me the exact result I am look...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you, Greg_Deckler.  The Final Word solution worked.  

 

I created this measure:

 
Daily Non-Compliant 2 = SWITCH(
TRUE(),
[Total Shipments]=0, ROUNDUP(sum('Ops Plan'[Weekly Planned Frequency])/265,0),
0
)
 
Then I created this measure:
Daily Non-Compliant = 
VAR __table = SUMMARIZE('Ops Plan','Ops Plan'[Carrier SCAC] ,"__value",[Daily Non-Compliant 2])
RETURNIF(HASONEVALUE('Ops Plan'[Carrier SCAC]),[Daily Non-Compliant 2],SUMX(__table,[__value]))


 
The totals now seem to be correct.