Forum Discussion
DAX help needed
Hi everyone, I have a dax query that works very slow, and my data model consist of 1 fact table as well as 2 basic dimension like dim date, can you suggest an optimized code for the dax que...
Your sample data only has Product IDs 2 and 3 but the DAX explicitly calls out IDs 0 and 1. Please clarify.
How many rows are in your actual table?
This article is likely relevant for your issue: https://www.sqlbi.com/articles/all-the-secrets-of-summarize/
well I have got performance issue and I have checked that article as well, but when i change it to addcolumns it is returning different value, so I want to optimize the query.
Doesn't this make more sense?
I have tried but it didnt return same value, do you think why?