Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Multi Level visual

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 getti...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

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

     

    Note: Please remove your sensitive data.