Forum Discussion
reynold522
3 years agoHelper II
Modified code not working
Hi all, I have following code, it works at the moment. DoDoverboundaryN = IF ( ISINSCOPE(TRACKSHEET[IoT_ID_NUMBER]), CALCULATE ( IF ( VALUES(TRACKSHEET[Capacitythreshold])> ABS ([Max...
- 3 years ago
reynold522
Before I start asking you questions, I would like you first try:DoDoverboundaryN = IF ( ISINSCOPE ( TRACKSHEET[IoT_ID_NUMBER] ), CALCULATE ( VAR MaxDoD = [Max DoD] VAR Capacitythreshold = SUM ( TRACKSHEET[Capacitythreshold] ) RETURN IF ( Capacitythreshold > ABS ( [Max DoD] ), 0, DIVIDE ( MaxDoD, Capacitythreshold ) ), ALL ( DimDate[Date] ) ) )
reynold522
3 years agoHelper II
Anonymous do you have any idea about this?
Thanks in advance!