I am relatively new to Power KPI and I am trying to understand the logic used by the As of Date. I have 2 measures in one of my tables and I when I place them in rows on a Power KPI visual they appear with the same values as they would if I placed them on Cards, however if a create another measure which adds the first 2 measures together, if I place this on the Power KPI in a separate row it simply shows the value of one of the measures that are being added together. It behaves this way regardless of whether I simply refer to the first 2 measures in the third or I recalc the third from first principles. If I place the third measure on a card I get what I would expect to get.
I suspect the issue is the impact of the Date attribute of the visual but I cannot work out what it is doing. I would prefer not to use it and let overall sliders control the data. Any assistance would be appreciated.
