web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Chart powerapp duplicate

Power Apps

Answered

Chart powerapp duplicate

(0) Share

Report

Report

Posted on by loopingmurdock

250

Hey Power Guys/Ladies.

I have a table that looks like this:

Etablishement	Purchase	Income
Carrefour	120
Carrefour	120
Dart		120

I would like to know how to show a chart column with unique etablishement and add the sum of the purchase, I did try this:

ForAll(
 Distinct(Filter(
 Add_Expensive, Purchase > 0),
 Etablishement
 ),
 LookUp(
 Add_Expensive,
 Etablishement = Result
 )
)

But have doubles and some not displayed.

Thanks Friends

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Gochix 1,937 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @loopingmurdock ,

You can try to use:
AddColumns( GroupBy(Add_Expensive,"Establishment","NewEST"), "TestCHART",Sum(Filter(NewEST,Purchase > 0),Purchase))

Was this reply helpful? Yes No
loopingmurdock 250 on at

Like (1)

Report
Copy link

Link copied!
Thanks
Never think of addcolumns() just did i small mod
AddColumns( GroupBy(Filter(Add_Expensive, Purchase > 0), "Etablishmnet","SumUp"), "Eta",Sum(Filter(SumUp,Purchase > 0),Purchase))

Was this reply helpful? Yes No
Verified answer

Gochix 1,937 Moderator on at

Like (0)

Report
Copy link

Link copied!

Glad you fixed your issue.

Please select accept a solution to close the topic.

Was this reply helpful? Yes No

Join the conversation