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

can you please provide with more details , like relationships , how many tables, the measure , a sample dataset