cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

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

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors