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/
Hi lbendlin , I have fixed the sample data, can you try with new one, and my main point in the dax query is I want to find total sales based on id,product and during calculation there is if condition and it should provide different topn strategy according to product_id.
I still don't understand the business logic. What are you trying to achieve?