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

     

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

hi HARSUE ,

 

How are FCT_Offertes and FCT_Orders related, or who is on the one side?

HARSUE's avatar
HARSUE
Frequent Visitor
7 months ago

Hello FremanZ

 

I have the following relations

 

FCT_Orders connections:

Leverdatum - Date table Many to one, single direction
Orderdatum - Date table Many to one, single direction
Startdatum - Date table Many to one, single direction
ArtikelCode - ArtikelCode in DIM_Artikel Many to one, single direction
OfferteNr - OfferteNr in FCT_Offertes Many to many both directions

 

FCT_Offerts connections:

Orderdatum - Date table Many to one, single direction
Startdatum - Date table Many to one, single direction
ArtikelCode - ArtikelCode in DIM_Artikel Many to one, single direction
ProjectCode - ProjectCode in DIM_ProjectCode Many to many both directions
OfferteNr - OfferteNr in FCT_Offertes Many to many both directions