Forum Discussion
Solved
TOTALYTD with 4 parameters
Hi, I'm a newby in powerbi and DAX. I have a measure that WORKS FINE but it has more parameters than it should have. My measure is: TOTALYTD(sum(GASTOS[IMPORTE]);GASTOS[FECHA];YEAR(GASTOS[FECHA]) =...
The fourth argument to TotalYTD is not a filter at all. It is a string specifying a year end date in order to calculate TotalYTD for fiscal year instead of calendar year. So we should not use another filter for the fourth argument. However, when you specify a filter condition, the intellisense signals that it is an error, but DAX engine is more tolerant during execution time which doesn’t sound like a good idea as it confused you. Power BI Team will file an internal bug to consider rejecting such expressions by the DAX engine. Thanks for reporting this.
Best Regards,
Herbert
Hi lcd，
I can reproduce your issue, I will report this issue internally and post back once I get any updates.
Thanks,
Lydia Zhang