I have tried different solutions for YTD formulas from this forum for my work but none seems to work. I suspect it my be due to the specific nature of the SQL(Directquery) I am using. See a screenshot:
@v-shex-msft , Can you explain a little further on what you described as the filtered range. I have tried using the suggested formula but to no avail. I created a formula that converted YES to 1 and NO to 0 ,based on which I calculated the value for summing up the YTD but still not working for me.