Forum Discussion

ramiro_gonzalez's avatar
ramiro_gonzalez
Frequent Visitor
1 year ago
Solved

Use Realated with calculate

Hi everyone, I’d appreciate your help. I’m trying to use a filter with the RELATED function inside CALCULATE, something like: CALCULATE(COUNTDISTINCT(Id), Sales[Date] < RELATED(Orders[ExpirationDate...
"DAX " "DAX help" 'Need help'
@related
  • Deku's avatar
    Deku
    1 year ago

    CALCULATE(

    COUNTDISTINCT(Id),

    Filter(

    Summarize(

    Orders,

    Sales[Date],

    Orders[ExpirationDate]

    ),

    Sales[Date] < Orders[ExpirationDate]

    )

    )

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi ramiro_gonzalez,

Thanks for reaching out to the Microsoft fabric community forum.

 

It looks like you are facing issue in your DAX. As Deku and bhanu_gautam both responded to query, please go through the responses and mark the helpful reply as solution.

 

I would also take a moment to thank Deku and bhanu_gautam, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

 

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.