Forum Discussion

HARSUE's avatar
HARSUE
Frequent Visitor
7 months ago
Solved

Measure

I have the following measure: Orderbedrag uit offertes = CALCULATE(     SUM(FCT_Orders[Bedrag_Excl_BTW]),     FCT_Orders[OfferteNr] <> BLANK(),     FCT_Orders[Artikelgroep] > 99,     USERELATI...
  • v-achippa's avatar
    v-achippa
    7 months ago

    Hi HARSUE,

     

    Thank you for the response. I request you to please provide the detailed solution so that it will be helpful for the other community members who has similar issue and you can accept that post as solution.

    Click on the three dots at the top right of the reply and there is an option for "Accept as Solution" click on that.

     

    Thanks and regards,

    Anjan Kumar Chippa

     

FBergamaschi's avatar
FBergamaschi
Icon for Super User rankSuper User
7 months ago

Hello HARSUE,

i think the point is understanding definitions. 

 

You wrote:

"I want ot allocate the orders to the date (year) where the quotation has been made"

Now in Power BI relationships propagate filters, so what you are doing calling USERELATIONSHIP is defining the year in calendar to mean "the year of the FCT_Offertes[StartDatum] column" for that measure

 

So when you select a year on a silcer (or on the row of a matrix of a given year), you should see with the measure the amount of orders with StartDatum in the currently selected period, plus the additional conditions you set in the measure (ArticlGroup and type of order) and external other slicers, nothing else is being considered.

 

It seems to me you need an additional filter to inject in the measure, to clean it up from orders than are in line with the above conditions, but you do not want them in your result set, am I correct?

 

I am starting from your original code:

 

Orderbedrag uit offertes =
CALCULATE(
    SUM(FCT_Orders[Bedrag_Excl_BTW]),
    FCT_Orders[OfferteNr] <> BLANK(),
    FCT_Orders[Artikelgroep] > 99,
    USERELATIONSHIP('Date'[Date], FCT_Offertes[StartDatum])
)

 

Thanks

 

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

HARSUE's avatar
HARSUE
Frequent Visitor
7 months ago

Thank you.

I solved the problem by changing the dates in the star scheme. Now the original measure works.