Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin 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.
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
Solved! Go to 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")
Data view for 2020
Data 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:
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.
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")
can you please provide with more details , like relationships , how many tables, the measure , a sample dataset
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
23 | |
11 | |
10 | |
9 | |
8 |