Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Want to develop a logic inside Power BI Desktop

Hi All, Trying to achieve same condition in Power BI,Please Help me: if(Calendar_Week_Relative = 0, sum({$<$(vSetChart), Stocking_Order_Type={'Outbound'}, Calendar_Week_Relative = {'<=0'}>} To...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous,

     

    Check measure below and take a look at this article.

     

    Measure 2 =
VAR w =
    SELECTEDVALUE ( Table1[week_relative] )
RETURN
    IF (
        NOT ( ISBLANK ( w ) )
            && w = 0,
        CALCULATE ( [Measure], Table1[week_relative] <= 0 ),
        [Measure]
    )

     

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

Anonymous,

 

Check measure below and take a look at this article.

 

Measure 2 =
VAR w =
    SELECTEDVALUE ( Table1[week_relative] )
RETURN
    IF (
        NOT ( ISBLANK ( w ) )
            && w = 0,
        CALCULATE ( [Measure], Table1[week_relative] <= 0 ),
        [Measure]
    )

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sam,

It works fine, thnaks muuch for the help!!