Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

ISBLANK in IF

Hi,   I have a measure (""Real_Orders" - connected with Database, future dates do not have a value) and a column ("Target_Orders" for each date in the next 6 months) and I want to subtract them, bu...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    v-jiascu-msft

     

    Thank you for your help.

    I solved it now a different way. I just filtered all future dates an subtract real orders with target orders.

     

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
9 years ago

Depending on how your [Real Orders] measure is created, you may need to test on [Real Orders]=0 instead of BLANK().

 

Hope this helps.

David

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Unfortunately not. It's the same.

    The measure (real_orders) is based on DISTINCTCOUNT.

    • dedelman_clng's avatar
      dedelman_clng
      Icon for Community Champion rankCommunity Champion
      9 years ago

      can you share your measure code and data model?

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi,

        I'm not sure what information you need (I'm new working with Power BI).

         

        Measure: "Real_Orders"=DISTINCTCOUNT(Database[ID])

        > Every unique ID is an order, if a customer selected more than one product, the ID is the same.

         

        Data Model: Do you mean, which data/tables are given and their relations?

         

        Database: As said: "Real_targets" results from these data

        Date: master excel file (date, week, month, year, etc.) - relation between Database and Date via date (dd:mm:yyyy)

        Target: excel file (target_orders, date) - relation between Target and Date via date (dd:mm:yyyy)

         

        I hope that helps understanding.