Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
RG92
New Member

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 one for a group. But there are several rows for the group and month. If I used the table in data view and filter it on 4 of the fields it's provides me with the rows that I want. However this won't be viewable by the user and want a measure that will specifically return that row and colum on the group based on the filters I can apply on the table. 
please help as it keeps summing all the rows or showing blank on every formula I have tired or gives me an error 

1 ACCEPTED SOLUTION

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

View solution in original post

5 REPLIES 5
RG92
New Member

Data view for 2020Data view for 2020Data modelData model

 

What I am trying to do is a measure for 2020. On the sheet I have two slicers MONTH and CO. 

 

I want a measure so that when they select a month on the slicer and CO. It will return the Score and if these are not selected the figure is blank. 

However I want the measure to be set to a specific category, and just return the exact value in the table for example when I filter it in a table view it returns the score like below:
Screenshot 2023-07-31 at 08.50.33.png

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

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.

Screenshot 2023-07-31 at 09.57.31.png

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
Memorable Member
Memorable Member

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.