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

     

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

Hi HARSUE 

 

USERELATIONSHIP('Date'[Date], FCT_Offertes[StartDatum]) only activates the date filtering on Offers table and SUM is coming from FCT_Orders.


Can you please check this measure and confirm
Orderbedrag uit offertes =
CALCULATE(SUM(FCT_Orders[Bedrag_Excl_BTW]),
FCT_Orders[Artikelgroep] > 99,
NOT ISBLANK(FCT_Orders[OfferteNr]),
TREATAS(VALUES(FCT_Offertes[OfferteNr]),
FCT_Orders[OfferteNr]))

 

Ensure you have a relationship between these tables FCT_Offertes[OfferteNr] (1) to FCT_Orders[OfferteNr] (M)

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.