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] )
    )
)

     

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi reynold522 

try to use DIVIDE function instead of the / operator 

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