DAX

[Abdult]

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

[Abdult]

not able to understand this - filter('Tablename','Tablename'[sale in Qty] = 60))

[Idrissshatila · Accepted solution]

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👍

Follow me on Linkedin

[Idrissshatila]

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👍

Follow me on Linkedin