Forum Discussion

xliu1's avatar
xliu1
Icon for Helper II rankHelper II
5 years ago
Solved

Level of Detail Calculation

I try to build a matrix visualization that shows the percentage of subtotal for each category within a table like this:  So the total of On Campus, High Flex, and Off Campus should sum to 100%...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    xliu1  What's the name of the column where High Flex/Off Campus/On Campus info comes from? Put that in the ALLSELECTED instead of your entire table and see if that helps.

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
5 years ago

xliu1  What's the name of the column where High Flex/Off Campus/On Campus info comes from? Put that in the ALLSELECTED instead of your entire table and see if that helps.

xliu1's avatar
xliu1
Icon for Helper II rankHelper II
5 years ago

Thank you for your response! It is the column of course site that has info High Flex/Off Campus/On Campus. I put that column in the ALLSELECTED, and I got results as I want.

Section_Total = CALCULATE (SUM ( Aggr_Headcount[Section_Count] ), ALLSELECTED(Aggr_Headcount[Course_Site]))