Forum Discussion
Decomposition tree :: custom value
How to get conformed total in category group ?
3 Replies
Not understanding what you mean. Can you explain in more detail?
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.
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
