Forum Discussion
Solved
DAX
I have below talable and i need to calacutale this in Power BI only those sale where quantity is 60. date sale in Qty 1 55 2 50 3 60 4 70 5 60 6 45 7 60 8 65 ...
Try this
calculate(sum('Sheet1'[sale in Qty]),filter('Sheet1','Sheet1'[sale in Qty]] = 60))If I answered your question, please mark my post as solution, Appreciate your Kudos👍
Hello,
calculate(sum('Tablename'[sales]),filter('Tablename','Tablename'[sale in Qty] = 60))
If I answered your question, please mark my post as solution, Appreciate your Kudos👍