Forum Discussion
Additive and semi-additive measures with PowerKPI Matrix EB
Hello,
I need a KPI matrix with additive and semi-additive measures.
The time frame is month/year.
Installing PowerKPI Matrix I get something like this:
The 1st KPI "Cash flow" should ADD the whole year. But instead on the "Actual" column it is showing the value of the last month of the year.
How do I tell this visual "give me the sum of all the months for this KPI and the last date for others".
The actual value is a measure that distinguishes the additive from the semi-additive measures using a logical test with a combination of CALCULATE + LASTDATE filter.
Thanks!
2 Replies
hi, webportal
I'm afraid you couldn't achieve it in PowerKPI Matrix. For other interactions are based on it, if you change the result by measure,
other interactions like Sparklines will be wrong.
and here is an example and introduction for PowerKPI Matrix, please try it.
Best Regards,
Lin
- Thanks, but that visual is so COMPLICATED!
All I need is a matrix with different KPIs that follow different measures (%, units).
That's all.
