Forum Discussion
Diego-mx
Advocate I
Advocate ICombine TREATAS filters in FILTER function
In a CALCULATE expression I can add different filters with commas. TotalSells = CALCULATE( SUM(Merchandise[prices]),
Merchandise[was_sold],
TREATAS( VALUES(Calendar[date]), Merchandise...
Diego-mxAdvocate I
Advocate IThe logic is that I want to find what proportion where sold in less than 10 days.
So the condition [sold_days] <= 10, gets turned into 1 and 0 and averaged.
Using ... IN VALUES(Calendar[date]) was helpful, but now the logical-to-numeric is not working.
I'll keep trying.
HI Diego-mx,
Can you please share some sample data with expect result to help us clarify your scenario?
Regards,
Xiaoxin Sheng