Forum Discussion

reynold522's avatar
reynold522
Icon for Helper II rankHelper 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] )
    )
)

     

reynold522's avatar
reynold522
Icon for Helper II rankHelper II
3 years ago

Thank you I tried this and wrote it in top of my code. it was not working due to measure divide column, 

is it possible to share your suggested code?

Thanks in advance!

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity 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
    Icon for Helper II rankHelper II
    3 years ago

    thank you a lot. It works