Modified code not working

[reynold522]

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!

[reynold522]

@v-tangjie-msft  do you have any idea about this?

Thanks in advance!

[tamerj1]

Hi @reynold522 

try to use DIVIDE function instead of the / operator 

[reynold522]

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 · Accepted solution]

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

thank you a lot. It works