topic Re: Set analysis in App Development

Set analysis

Neha121 — Wed, 01 Oct 2025 03:02:48 GMT

Hi Team,

There are lots of filters and fields on my dashboard for one of the line chart I want that chart should be filtered based on only two filters and for rest of the filters it should not stay unchanged.

I know below formula will have no impact when field1 and field 2 is selected but I can't add all the fields here.

Sum({<[Field1]=,Field2=>}[Net Incurred Cost])/Sum([Total Net Incurred])

so my requirement is for field 3 and field 4 only the chart having this formula should work and for rest of the fields it shouldn't like positive reverse

Re: Set analysis

robert_mika — Wed, 01 Oct 2025 02:25:09 GMT

Hi Neha,

Sum({1<[Field1]=$::Field1,[Field12]=$::Field2>}[Net Incurred Cost])/Sum([TMF Net Incurred])

Re: Set analysis

Neha121 — Wed, 01 Oct 2025 03:21:35 GMT

this didnt work

Re: Set analysis

robert_mika — Wed, 01 Oct 2025 03:33:49 GMT

I made mistake my first solution

Sum({1<[Field1]=$::Field1,[Field12]=$::Field2>}[Net Incurred Cost])/Sum([TMF Net Incurred])

Shal be

Sum({1<[Field1]=$::Field1,[Field2]=$::Field2>}[Net Incurred Cost])/Sum([TMF Net Incurred])

But you probably spotted that.

Did you try with one field only?

Why does not work?

Re: Set analysis

Neha121 — Thu, 02 Oct 2025 00:56:42 GMT

yes you are right the first one has issue. it works now

(Sum({1<[Field1]=$::Field1,[Field2]=$::Field2>}[Net Incurred Cost])/Sum([Net Incurred])