Forum Discussion
DAX applied on Table filter dynamically
Hello, I have a TABLE A with multiple data. I create a TABLE B with several CALCULATE functions using data from TABLE A. No relation between TABLE A & TABLE B. I would like that calculus mad...
ngiolet91 , You use the slicer of Table A in Table B to measure using treatas, or vice versa
https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/
Thanks!
I am trying to figure it out but I do not get how "treatas" works.
This is one of the column calculated in Table B (BugCalendar) from Table A (BugCurve)
Open =
VAR Data = 'BugCalendar'[Date]
VAR Conta = CALCULATE(COUNTROWS(('BugCurve')),
(NOT ISBLANK(BugCurve[Open]) && BugCurve[Open] <= Data) &&
((BugCurve[Processing]) >= Data || ISBLANK(BugCurve[Processing])) &&
((BugCurve[Rejected]) >= Data || ISBLANK(BugCurve[Rejected])) &&
((BugCurve[Closed]) >= Data || ISBLANK(BugCurve[Closed]))
)+0
RETURN
IF(Data<= TODAY(),Conta,BLANK())
Filtering BugCurve using slice does not affect BugCalendar calculus. How to use TREATAS here?
Regards
Filtering BugCurve using slice does not affect BugCalendar calculus. How to use TREATAS here?
Regards