Forum Discussion
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...
CALCULATE(
COUNTDISTINCT(Id),
Filter(
Summarize(
Orders,
Sales[Date],
Orders[ExpirationDate]
),
Sales[Date] < Orders[ExpirationDate]
)
)
bhanu_gautam
Super User
Super Userramiro_gonzalez , Use
DAX
CALCULATE(
COUNTDISTINCT(Sales[Id]),
TREATAS(
VALUES(Sales[Date]),
Orders[ExpirationDate]
)
)