web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Calculation in Gallery

Power Apps

Answered

Calculation in Gallery

(0) Share

Report

Report

Posted on by Sam70

285

Hi,

Below is the data structure of two lists (Heatmap and VDUList)

(Heatmap) and (VDUList)

Values under Service Line are from VDUList. User will select unique Category values from a dropdown. Based on the selection, rating counts are to be listed. For Category-Network, if Rating falls between 1 to 5, then the count (2) should be under RED, if rating is between 6-7, then its count (2) should be under AMBER and if its 8-10 then the count (1) should be under GREEN. NA values are to be neglected.

Account in Scope will be the sum of RED, AMBER and Green for a specific VDU. FS in my case.

Kindly help.

Regards

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

nickellis74 432 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Sam70 this seems a complex way of doing it. The solution is to have a different labels under each column with a formula like
If(And(CountRows(Filter(Heatmap,Rating <> "NA")>5,CountRows(Filter(Heatmap,Rating <> "NA")<8),CountRows(Filter(Heatmap,Rating <> "NA"))
Accepting that your format may be mandated by the business, may I suggest a method that involves less calculating and thus will be quicker to execute?
Have a single label with the value
CountRows(Filter(Heatmap,Rating <> "NA")
And then switch the background color attribute based on the Text value of the label.

Was this reply helpful? Yes No
Sam70 285 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @nickellis74 ,
taking clue from the formula, a small change was made and got what was required.
Thank You
Regards

Was this reply helpful? Yes No

Join the conversation