Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
bml123
Post Patron
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

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.

RicoZhou_0-1656495789221.png

 

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.

 

View solution in original post

8 REPLIES 8
SpartaBI
Community Champion
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)

HI @SpartaBI 

I have data like this

 

CurrentNext MonthDifference% changeMeasure1
100604040.00%No
50302040.00%No
2019.750.251.25%Yes
3029.50.51.67%Yes
60204066.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

CurrentNext MonthDifference% changeMeasure1Measure
100604040.00%No0
50302040.00%No0
2019.750.251.25%Yes0.25
3029.50.51.67%Yes0.5
60204066.67%No0
Total    0.75

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.

RicoZhou_0-1656495789221.png

 

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.

 

SpartaBI
Community Champion
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]))))

Hi @SpartaBI 

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

SpartaBI
Community Champion
Community Champion

@bml123 can you maybe share your file?

Hi @SpartaBI 

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

I have given you the sample data above.

SpartaBI
Community Champion
Community Champion

@bml123 I will PM you

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.