Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 9 | |
| 5 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 23 | |
| 12 | |
| 11 | |
| 9 | |
| 8 |