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'}>} Total Total_$(vMeasure)),
sum({$<$(vSetChart), Stocking_Order_Type={'Outbound'}, Calendar_Week_Relative = {'>0<=12'}>} Total_$(vMeasure)))

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

     

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Please ignore $(vSetChart) and Total_$(vMeasure), just want to impement If logic to Date dimenssion.

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    7 years ago

    Anonymous

     

    Could you please provide the screenshots of your sample data and the result you expected?

     

    Thanks & BR

    Ryan

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I don't have any sample data, Here i'm trying to achieve the solution like:
      Sample Data:
      week_relative:            Measure:
      -1                               10
      -2                               20
      (Blank)                       30
      0                                40
      1                                 50
      2                                 60
      Trying to achieve,
      if ([Week_relative]=0,
      calculate(sum(measure),[week_relative]<=0    I.e. (10+20+30+40),
      else show the result as it is
      week_relative     Measure
      1                          50

      2                          60

      • v-chuncz-msft's avatar
        v-chuncz-msft
        Community 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]
    )