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 |
| 9 | 77 |
| 10 | 60 |
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👍
3 Replies
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👍
not able to understand this - filter('Tablename','Tablename'[sale in Qty] = 60))
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👍
