Set analysis result doesn't change

[markp201]

I have 2 kpi with the measure - sum({$<Location={Dealer}>}Orders) and sum({$<Location={Home}>}Orders)

There are only two options for Location - Home and Dealer

I have various filters including location.  When I select Home or Dealer for the location neither KPI changes.

The KPI does change when other filters are selected.

I created a table with Location and SUM(Orders) and this works when filtering the Location.

Why does the KPI not change for the one filter?

[agigliotti · Accepted solution]

maybe this:

sum( {$< Location *= {'Dealer'} >} Orders )

I hope it helps

[vijetas42]

You have already filter out data based on location in expression sum({$<Location={'Dealer'}>}Orders) so it's not changing location filter and get affected by other filer. when you have sum(orders) and select values in location either Dealer or Home you will see same value as getting displayed on above expressions.

Regards,

Vijeta