Forum Discussion

reynold522's avatar
reynold522
Helper II
3 years ago
Solved

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...
help needed
  • tamerj1's avatar
    tamerj1
    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] )
    )
)

     

tamerj1's avatar
tamerj1
Community Champion
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's avatar
reynold522
Helper II
3 years ago

thank you a lot. It works