Set analysis

[Neha121]

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

[robert_mika]

Hi Neha,

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

[Neha121]

this didnt work

[robert_mika · Accepted solution]

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?

[Neha121]

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

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