Forum Discussion
Solved
Select specific value in the row & column
I am struggling I have a table in power bi of 251,104 rows and 11 columns I want to use a dax formula but can't get anything to work. I have two slicers on my page one for month and ...
Can you please try
=CALCULATE(SUM('2020'[Score]),'2020'[Category] = "Category 1")
OR
=CALCULATE(SUM('2020'[Score]),ALLEXCEPT('2020','2020'[Month],'2020'[Co]), '2020'[Category] = "Category 1")
Thank you so much for getting back so quickly. It doesnt seem to do the trick. It does the right sum but I want it to only specify for category 1 so it returns the single cell of 85.
eliasayyy
Memorable Member
Memorable MemberCan you please try
=CALCULATE(SUM('2020'[Score]),'2020'[Category] = "Category 1")
OR
=CALCULATE(SUM('2020'[Score]),ALLEXCEPT('2020','2020'[Month],'2020'[Co]), '2020'[Category] = "Category 1")