topic Re: Use Realated with calculate in DAX Commands and Tips

Use Realated with calculate

ramiro_gonzalez — Tue, 08 Apr 2025 05:55:34 GMT

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])).
I get an error saying that the column used in RELATED doesn’t exist. I know a row context is needed, but in this case I want to avoid using FILTER to filter a whole table.

Re: Use Realated with calculate

bhanu_gautam — Tue, 08 Apr 2025 06:17:23 GMT

ramiro_gonzalez , Use

DAX
CALCULATE(
COUNTDISTINCT(Sales[Id]),
TREATAS(
VALUES(Sales[Date]),
Orders[ExpirationDate]
)
)

Re: Use Realated with calculate

Deku — Tue, 08 Apr 2025 08:44:09 GMT

CALCULATE(

COUNTDISTINCT(Id),

Filter(

Summarize(

Orders,

Sales[Date],

Orders[ExpirationDate]

Sales[Date] < Orders[ExpirationDate]

)

Re: Use Realated with calculate

Anonymous — Tue, 08 Apr 2025 21:12:18 GMT

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.