topic Re: Modified code not working in DAX Commands and Tips

Modified code not working

reynold522 — Fri, 13 Jan 2023 16:39:25 GMT

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!

Re: Modified code not working

tamerj1 — Fri, 13 Jan 2023 20:42:11 GMT

Hi reynold522

try to use DIVIDE function instead of the / operator

Re: Modified code not working

reynold522 — Mon, 16 Jan 2023 09:14:37 GMT

Anonymous do you have any idea about this?

Thanks in advance!

Re: Modified code not working

reynold522 — Mon, 16 Jan 2023 09:17:14 GMT

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!

Re: Modified code not working

tamerj1 — Mon, 16 Jan 2023 11:24:19 GMT

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

Re: Modified code not working

reynold522 — Mon, 16 Jan 2023 12:23:16 GMT

thank you a lot. It works