I have below talable and i need to calacutale this in Power BI only those sale where quantity is 60.
Go to Solution.
Try thiscalculate(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
View solution in original post
not able to understand this - filter('Tablename','Tablename'[sale in Qty] = 60))
calculate(sum('Tablename'[sales]),filter('Tablename','Tablename'[sale in Qty] = 60))
Find out more about the May 2023 update.
Share your Data Story with the Community in the Data Stories Gallery.