Dynamic KPI

[laurentubesing]

Good Morning ... 

I'm working on a KPI that is dynamic to the filter for the entire sheet.  The data would be directly pulled from an excel sheet.

In my mind, I think about it like this: Sum({$<[Primary Business Segment]={'USER SELECTION'}>}[2019])

So, based upon the users' selection of the primary business segment the corresponding 2019 value would be displayed. I would like to default to be Sum({$<[Primary Business Segment]={'Grand total'}>}[2019]) and then change based upon user selection.

Sorry if this is a dumb ask!

[dplr-rn]

its not clear why you need Set Analysis here?
Sum([2019]) will by default show total and if a user select a Primary Business Segment he will get only those.
please elaborate

[laurentubesing]

Thanks for the reply!  I can't sum[2019] because it sums that whole column and I just need to spit out the number within the table.

See below ... I need the 2019 number to come out when the primary business segment is selected and the default for no selection would the the "grand total" number below.  If i use sum[2019] is just adds up that column and gives an inaccurate number

Primary Business Segment	2017	2018	2019
Aviation Additive	10.36	38.96	37.08
Aviation Aeroderivatives			0
Aviation AvioAero	20.37	19.86	19.17
Aviation Avionics & Digital Systems	13.03	23.42	22.63
Aviation Business & General Aviation & Integrated Systems	6.75	18.24	30.76
Aviation China		0	0
Aviation Commercial Engines	13.58	28.02	45.43
Aviation Communications & GE Advantage	24.69	22.99	0
Aviation Digital	31.21	27.33	43.22
Aviation Digital League		0	0
Aviation Digital Technology			0
Aviation Engineering	24.63	31.21	46.52
Aviation Finance	11.04	14.88	18.77
Aviation Global Law & Policy			0
Aviation Headquarters	7.94	12.05	24.84
Aviation Human Resources	17.3	82.62	74.18
Aviation Legal & Business Development	76.75	38.38	32.89
Aviation Military Systems	28.04	27.42	51.97
Aviation Sales & Marketing	14.29	26.07	19.22
Aviation Services	25.23	31.45	38.07
Aviation Supply Chain	15.05	16.57	17.57
Aviation Transitions	0	0	0
Grand total	16.51	20.98	25.53

[dplr-rn]

Ok.

you can try this 

if(GetSelectedCount([Primary Business Segment])>0,Sum([2019]),Sum({$<[Primary Business Segment]={'Grand total'}>}[2019]) )