Multi Level visual

[Anonymous]

Hi

I have this visual that is showing 3 categories day by day. I know that I could go up and see month by month or quarter but is there any way to sum up 3 categories and see a total but still getting day by day. So being able to see by categories day by day and also the total day by day.

two ways of hierarcry 

[amitchandak]

@Anonymous ,  I think you need to use allexcept 

examples

calculate([measure], allexcept(Table, Table[Category]))
or
calculate([measure], allexcept(Table, Table[Day]))

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

@amitchandak How do I share info? I do not see any attach icon here T_T

[v-xuding-msft]

Hi @Anonymous ,

You could upload your sample to OneDrive for Business and share its link with us. Thanks!

Note: Please remove your sensitive data.

[Greg_Deckler]

@Anonymous Not sure I follow. Maybe use ALLEXCEPT('Table',[Day]) sort of syntax?

Sorry, having trouble following, can you post sample data as text and expected output?

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.