Issue with set analysis expression

abc_18 — Tue, 21 Dec 2021 20:43:45 GMT

Hi,

I have a table chart in one of the dashboard, and data is as below:-

Now I have to colour code the measure column(Qty On Hand), based on the condition and codition is as below:-

I need to sum Qty on Hand for product / Customer and if the total is greater than the Level column

then it is Blue.Here the level column is on the per invoice line so we would need to AVG the value.

for ex:- if sum(Qty on Hand )> Level, it means (2>1) so it should be blue

Plesae suggest, how to write expression for this.

Re: Issue with set analysis expression

Vegar — Fri, 27 Sep 2019 12:47:06 GMT

Try this:

=if( sum( TOTAL <Customer> [Qty on Hand] ) > only(level), Blue(), Red())