Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
reynold522
Helper II
Helper II

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!

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

 

View solution in original post

5 REPLIES 5
reynold522
Helper II
Helper II

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

 

Thanks in advance!

tamerj1
Super User
Super User

Hi @reynold522 

try to use DIVIDE function instead of the / operator 

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!

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

 

thank you a lot. It works

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.