Configure editable write-back measures in Power BI
At this stage we assume you have:
- Created a fact storage table for storing planning data
- Connected your Power BI model using a DirectQuery to the Aimplan database an the storage table
- Created at least one measure inside the Aimplan admin portal
Let's assume that we in the Aimplan admin portal has created the measure 'PlanSalesAmount' with the MeasureKey 'M1'. We have also have a Power BI table called 'FactPlanningData' which is connected via DirectQuery against the Aimplan fact-planning table you have configured.
You will in Power BI see your planning table like this:
But the Value field may contain both salaries, prices, quantities and a lot of other measures, not only the M1 PlanSalesAmount-measure. How can we tell Power BI that we want a specific Power BI measure only showing the M1 measure.
This is easy to achieve by just create a Power BI calculated measure like this:
The result will be a single measure, that you can use in any Power BI chart or table or other visual to view your 'PlanSalesAmount' numbers per month, product, customer and any other dimension you have configured.
This measure can reside within the FactPlanningData table, or instead reside and be grouped in a separate so called 'measure table' in Power BI. The advantage of this approach is to group your measures and make them easily accessible when designing reports. The picture below shows a measure table called 'PlanningMeasures' containing the two calculated measures above.
