Decomposition tree :: custom value

[Anonymous]

How to get conformed total in category group ?

[amitchandak]

Not sure I got it but you have to get a new table like this in Dax

union

(

Summarize(Table,table[Country],"Category","Confirmed","Cases",[Confirmed Cases]),

Summarize(Table,table[Country],"Category","Recoveded","Cases",[Recovered Cases])

/// Add more

)

But you should have this a category already

Or do the data level unpivot of measure

https://radacad.com/pivot-and-unpivot-with-power-bi

[Greg_Deckler]

Not understanding what you mean. Can you explain in more detail?

[Anonymous]

data source : https://en.wikipedia.org/wiki/2019%E2%80%9320_coronavirus_pandemic#covid19-container

sample data:

Locations	Cases	Deaths	Recov.
United States	142410	2505	4767
Italy	97689	10779	13030
China	81470	3304	75770
Spain	85195	7340	16780

By using this data i want to create a decomposition tree similar to the above screenshot. 

level 1 for decomposition tree : total cases( sum of cases for all location)

Level 2 for decomposition tree:  location-wise split of total cases.

Level 3 for decomposition tree:  for each location i want to split into no of deaths, no of recover and total cases for each location (same from level2 similar to the screenshot above.

please suggest if this makes sense.