Forum Discussion

RG92's avatar
RG92
New Member
3 years ago
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 ...
  • eliasayyy's avatar
    eliasayyy
    3 years ago

    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")

eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago

it should be fairly straight forward maybe try 

score = CALCULATE(SUM('2020'[Score]))

however if you only want to insert for example date, company and co only in the tables ,

maybe try

score = CALCULATE(SUM('2020'[Score]),ALLEXCEPT('2020','2020'[Month],'2020'[Co],'2020'[Category]))

RG92's avatar
RG92
New Member
3 years ago

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's avatar
    eliasayyy
    Icon for Memorable Member rankMemorable Member
    3 years ago

    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")