Forum Discussion
Visualisations Advice
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
Ok this time my mistake. Just remove the "dot" from the variable name. Fore example instead of :
A.CurrentMonth
write :
A_CurrentMonth
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- Here is the error messageAmount Recovered =VAR A_CurrentMonth = [Current Month Succ Rec uninsured loss]--insert your measure for Current Month - A. Uninsured Loss RecoveriesVAR A_YearTD = [YTD Recoveries No Successful Recoveries Uninsured Loss]--insert your measure for YTD - A. Uninsured Loss RecoveriesVAR A_Total = [Total Recoveries No Successful Recoveries Uninsured Loss]--insert your measure for Total - A. Uninsured Loss RecoveriesVAR B_CurrentMonth = [Current Month Succ Rec Motor Recoveries]--insert your measure for Current Month - B. Motor RecoveriesVAR B_YearTD = [YTD Recoveries No Successful Recoveries MV]--insert your measure for YTD - B. Motor RecoveriesVAR B_Total = [Total Recoveries No Successful Recoveries MV]--insert your measure for Total - B. Motor RecoveriesRETURNSWITCH (TRUE,SELECTEDVALUE ( 'Recoveries Columns'[Value1] ) = "Current Month"&& SELECTEDVALUE ( 'Recoveries Row'[Value] ) = "A. Uninsured Loss Recoveries", A.CurrentMonth,SELECTEDVALUE ( 'Recoveries Columns'[Value1] ) = "Current Month"&& SELECTEDVALUE ( 'Recoveries Row'[Value] ) = "B. Motor Recoveries", B.CurrentMonth,SELECTEDVALUE ( 'Recoveries Columns'[Value1] ) = "YTD"&& SELECTEDVALUE ( 'Recoveries Row'[Value] ) = "A. Uninsured Loss Recoveries", A.YearTD,SELECTEDVALUE ( 'Recoveries Columns'[Value1] ) = "YTD"&& SELECTEDVALUE ( 'Recoveries Row'[Value] ) = "B. Motor Recoveries", B.YearTD,SELECTEDVALUE ( 'Recoveries Columns'[Value1] ) = "Total"&& SELECTEDVALUE ( 'Recoveries Row'[Value] ) = "A. Uninsured Loss Recoveries", A.Total,SELECTEDVALUE ( 'Recoveries Columns'[Value1] ) = "Total"&& SELECTEDVALUE ( 'Recoveries Row'[Value] ) = "B. Motor Recoveries", B.Total)
You have to change those as well
Thats worked - there are no errors. So where do you want me to put the fields in the cross tab visualisation like this or is there a stage inbetween?
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
Hi tamerj1
The help you have provided has been amazing - here is the result below. There are the other rows to add ie Amount Recovered, Team Fee Income for both Uninsured Loss Recoveries and Motor Recoveries. Is this too much to try and help me with or are you okay too? I understand I have take a lot of your time already?
Great!
Now the measures are showing the grand total as they are not filtered by anything. So start selecting something on the the slicers and see the results.USe the same measure. the only thing yuou need to change is the measure names inside the master measure. So you will have total 3 master measures. Create the other two and add them to the values of the matrix
Im my example can you tell me what meaure you are referring to when you say " Use the same measure" do you mean copy them ?