Forum Discussion

Vkt's avatar
Vkt
New Member
2 years ago

undefined

Thanks in advance.

I have two fields expected date and requested date in a fact table.

I have created a measure like this:

If (expected date<> blank && expected date < requested date, quantity, blank)

Quantity is measure which already created

Unfortunately its not working as measure in my power bi.

It's giving an error : a table of multiple value was supplied

 

Any alternative to create this above condition as measure.

 

Regards,

Tips and Tricks

3 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    2 years ago

    Hey Vkt ,

     

    share the exact DAX code of your measure.
    Whenever you are creating a measure you have to wrap a column reference inside an aggregation function like MAX('<your table name>'[the column name]). It also can become possible to wrap the aggregation function inside a CALCULATE( ... ) to modify the current filter context.

    If you are new to measures, start here: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-measures?WT.mc_id=DP-MVP-5003068

    Hopefully, this provides some additional insights to tackle your challenge.

    Regards,

    Tom

     

  • Vkt's avatar
    Vkt
    New Member
    2 years ago

    TomMartens Thanks for your response.

    If (expected date<> blank && expected date < requested date, quantity, blank)

     

    The above expression is a dax measure but in my scenario I can't use aggregation.

     

    • TomMartens's avatar
      TomMartens
      Super User
      2 years ago

      Hey Vkt ,

       

      what you posted is not a measure, at best it's pseudo code.
      If you can't use an aggregation function, then you have to use a table iterator function like MAXX, or SUMX. Table iterator functions create a row context, this allows to reference a column w/o using an aggregation function.

       

      Regards,

      Tom