Percentage in matrix when expanding rows

[Anonymous]

Hello,

I attach the dataset (excel) and the pbix file here : https://www.dropbox.com/sh/d8n4wxwxudlppgc/AAATUxKxmxSiFHkkmdWVvF_Za?dl=0 

My problem is in the matrix of the 2nd tab named "Area". It's about the measure "% coste total 2".

I would like this measure to show me how the cost is distributed between all the areas, which works fine because my total 100%. So far so good.

But I also need to know, for each area (in other words, when I expand an area), what is the distribution of the cost in this particular area. For example, when I expand the area "Cloud", the sum of the 3 rows ( 1 row = 1 client) should be 100%. For the moment it displays the % of the total cost, not the % inside the area. The thing is, in my first measure "% coste total" I do have it for the clients but the result is not good at the area level. If you put the 2 measures in the matrix you will understand better.

Please let me know if this is not clear. Also if you have any documention/ressource/video/article about how to deal with percentages (I think with ALL, ALLSELECTED, etc) feel free to share it with me.

thank you very much for your time and your help.

Best regards

[Anonymous]

Hi @Anonymous ,

Check the measure.

% coste total 2 = DIVIDE([Coste],CALCULATE(SUM(Detalle[STD Cost por jornada]),FILTER(ALL(Detalle),Detalle[Área]=SELECTEDVALUE(Detalle[Área]))))

Best Regards,

Jay

[Anonymous · Accepted solution]

Hi Jay,

Thank you for your suggestion. The level of area should not be 100%.

I actually found a way to show what I wanted with this formula : 

% inversión por área y por cliente = IF(ISINSCOPE(Acciones[Clientes]), [% coste total 3], DIVIDE([Inversión], CALCULATE([Inversión],ALL(Detalle))))

The model has been optimized and some names too (here inversion=coste). I hope it can help someone that faces the same requirement.

Thank you,

BR

[Jihwan_Kim]

Hi, @Anonymous 

Please correct me if I wrongly understood your question.

Please try the below measure.

 

% coste total 3 = DIVIDE([Coste], CALCULATE([Coste], ALL(Clientes[Clientes])))

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[Anonymous]

Hi Jihwanm,

Thank you for your help. Actually this measure does not respond to the requirement because with it we see 100% for each area, whereas we should also see how the cost is divided between each area. You know what I mean? I think maybe a measure with ISINSCOPE or something like that could solve the problem but I am not sure.