Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

SpeckyD

IF not Summing

Submitted by on ‎06-28-2023 02:14 PM

Hi. Hoping someone can help. 
I have a few measures in my report which all have a total sum at the bottom of the list. 
My last measure looks at one of the last measures and does an IF statement to see if it is 0. If so it gives it a 1. If not it gives it a 0. This works fine at the row level and shows the 0 or 1 value correctly. However the total for the column just shows a 1. I would expect it to do a sum and show 500+. I've tried a sum on the measure but it doesn't allow it. I've tried setting the value to number and no luck. Out of ideas......

Status: Investigating
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎06-28-2023 06:29 PM

Hi @SpeckyD ,

 

It sounds like you are trying to create a calculated column in your report that checks if a certain measure is equal to 0, and then returns a 1 or 0 accordingly. However, when you try to sum up this calculated column, you are only getting a value of 1 instead of the expected sum. One possible solution is to use a DAX measure instead of a calculated column.

 

Best regards.
Community Support Team_Caitlyn

Idea Statuses