Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
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