Unanswered

Sum with PowerBI Integration filter - Dynamic Gallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

I'm new in power apps, and I'm bulding a commentary app for power bi report.

I want to do a sum using a power bi filter. When you select a country, I want it to sum only the comment IDs that appear from the selected country. But it returns a incorrect total value.

I'm using this code:

Sum(
 Filter(
 Opportunities;
 //IdLabel.Text = ID
 //ID = Value(idvalue
 Country in PowerBIIntegration.Data.Country
 );
 VolumeLabel
)

and I get this:

power apps.PNG

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
You should be able to use this formula

Sum( {Table}, {NumericalFormula} )

Replacing {Table} with whatever formula you are using in the Items property of your datatable or gallery and {NumericalFormula} with VolumeLabel

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Thanks for your answer, but I already tried [Sum( Opportunities(table); volumelabel), and return a wrong value again

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
This solved my problem:
Text( Sum( Filter( Gallery2.AllItems; Country in PowerBIIntegration.Data.Country ); VolumeLabel ) )

Was this reply helpful? Yes No