Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

add measured /calculated value in matrix row

Hi,   i have an export of financial data (journal entries). Based on the GL account i have dfined a higher hiearchy level. I allready created a mapping table that contains all the GL accounts with ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , Make sure the reference number is present in the dimension

 

Then create measure like

Switch( true() ,

Max(Mapping [Reference]) =3,

calculate([measure] , Mapping [Reference] =2) -calculate([measure] , Mapping [Reference] =1)

Max(Mapping [Reference]) =6,

(calculate([measure] , Mapping [Reference] =2) -calculate([measure] , Mapping [Reference] =1) ) -

calculate([measure] , Mapping [Reference] =4) + calculate([measure] , Mapping [Reference] =5)

Max(Mapping [Reference]) =9,

<Add for 9>,

[Measure]

)

 

It will be a very similar approach like

Power BI Modeling- Unselected values as others - https://youtu.be/HX4pgexYwf4

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi amitchandak 

    thanks for your reply.
    unfortunatly it is not very usefull in my case.

     

    mapping table is just a table in wich all GL accounts are mapped to reference number (280 rows in total).

    So i will not work to just put reference number 3,6 and 9 in this table and then calculate the total amount for these reference numbers via the measure you suggested...

    thanks any way:)