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

     

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
7 months ago

Hi HARSUE,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you cengizhanarslan, FBergamaschi, krishnakanth240 and techies for the prompt response. 

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa

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.

How can i close this question?

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support
    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

     

    • HARSUE's avatar
      HARSUE
      Frequent Visitor
      7 months ago

      I have a model with multiple dates. I made a DIM table withe the start date and connected all othter FCT tables to this DIM table. The Date table is connected to the new DIM table. This works