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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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 PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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