cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Post Patron

## Totals in table not showing

I have a measure like this in a table where Amount is a column and Measure1 is measure

Measure = if([Measure1]="Yes",CALCULATE(SUM([Amount])))

It's not showing the Totals in the table, Totals is blank

I tried CALCULATE(SUM([Amount]),[Measure1]="Yes")

but it's giving error-A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

How can I correct it?

1 ACCEPTED SOLUTION
Community Support

Hi @bml123 ,

I think you can try this code to create a measure.

``Measure2 = CALCULATE(SUM('Table'[Difference])+0,FILTER('Table',[Measure1] = "Yes"))``

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

8 REPLIES 8
Community Champion

@bml123 You should stick with V1: if([Measure1]="Yes",CALCULATE(SUM([Amount]))) but you need to see why this measure is not equal to "Yes" fot the total and fix it. If you can't then maybe best to share a sample file or data (not screenshots)

Post Patron

I have data like this

 Current Next Month Difference % change Measure1 100 60 40 40.00% No 50 30 20 40.00% No 20 19.75 0.25 1.25% Yes 30 29.5 0.5 1.67% Yes 60 20 40 66.67% No

where Measure1 is a measure to flag if the percentage is within -2% to 2%. I want to add the

'Difference 'column where meaure 1 is Yes. It's showing the numbers in the table but totals is 0.

Here is the desired output

 Current Next Month Difference % change Measure1 Measure 100 60 40 40.00% No 0 50 30 20 40.00% No 0 20 19.75 0.25 1.25% Yes 0.25 30 29.5 0.5 1.67% Yes 0.5 60 20 40 66.67% No 0 Total 0.75
Community Support

Hi @bml123 ,

I think you can try this code to create a measure.

``Measure2 = CALCULATE(SUM('Table'[Difference])+0,FILTER('Table',[Measure1] = "Yes"))``

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Champion

@bml123 ok , so you need to wrap your measure with SUMX.
Try first something like:
SUMX('Table', if([Measure1]="Yes",CALCULATE(SUM([Amount]))))

Post Patron

It's not the sum of Amount I want, it's the sum of Difference column.
As per your suggestion, I tried

SUMX('Table', if([Measure1]="Yes",Difference))

It didn't work, it gave the total of all the data ignoring Measure1=Yes

Community Champion

@bml123 can you maybe share your file?

Post Patron

Sorry, can't share the file as it has confidential data.

I have given you the sample data above.

Community Champion

@bml123 I will PM you

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors