Forum Discussion
Solved
Visualisations Advice
Hi I want to display the following table - with amazing help I have been able to produce measue here displayed as the column rows but I am wanting to know how to get the current month measures, (...
You have created a master measure for the number of revoveries in which you grouped 9 measures.
now create another master measure for amount recovered that groups the 9 relared measures the same way as the first one. Copy the same master measure only change its named and the 9 measure names inside.
then do the same for th team fee income.
Then adf the these two master measures into the values of the matrix
Hi spandy34
It should work but we need to trick PowerBi in oreder to reach our distination. See in this screenshot is working with me
In order to trick it we need to modify the code for 'Table'
Table = { ( "Current Month", "A. Uninsured Loss Recoveries", 1 ), ( "YTD", "B. Motor Recoveries", 2 ), ( "Total", "Total", 3)}Now follow the following steps: please follow the mouse curser
Here is the table - looking more like we need - the values look very high