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 DoD] ), 0, [Max DoD] ),
ALL ( DimDate[Date] )
)
)

Instead returned measure: [Max DoD] in if clause, I would like to change it to a formula:
[Max DoD]/VALUES(TRACKSHEET[Capacitythreshold]

the reuslt will be a measure divide by a column in a table, it sounds weird, however if we put it to a visual table with IoT_ID_NUMBER as first column, then calculation [Max DoD]/VALUES(TRACKSHEET[Capacitythreshold] is only one number
I modified the code as following, the red color is the place modified.
DoDoverboundaryN =

IF (
    ISINSCOPE(TRACKSHEET[IoT_ID_NUMBER]),

CALCULATE (
IF ( VALUES(TRACKSHEET[Capacitythreshold])> ABS ([Max DoD] ), 0, [Max DoD]/VALUES(TRACKSHEET[Capacitythreshold] ),
ALL ( DimDate[Date] )
)

the measure wont work anymore, can someone help me in this case?
 
Thanks in advance!

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

     

5 Replies

    • reynold522's avatar
      reynold522
      Helper 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
        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] )
    )
)