Forum Discussion
Calculate Sales by Price Type
Hello I have a calculated table. It show the amount of sales by type of price. I do not know how to leave rows with values in this calculated table and delete empty ones. Please, help. Maybe someo...
clarification
it is necessary that the number of unique combinations of Product_id Date in Sales and Prices per dates be the same. In the example, it should be 35
http://prntscr.com/ql5qm5
I try to continue the DAX formula with TREATAS to create a virtual relationship.
And TREATAS returns the correct result 35 rows
But then, something goes wrong ... 698 rows
The problem turned out to be solved, but not sure about the speed on a large amount of data ..
The question remains open. Can someone tell me another solution
https://prnt.sc/ql6h0t🤔 very very slow ... need to look for another solution ..