Greg, thanks for your asssistance.
My Column headings are using the field ESI_CATEBI[Pass]
My Values are using the field ESI_CATEBI[Tag_ID]
I want the calculation to be Totals by Pass/Total Records. Using the concepts you outlined above, the closet I've gotten is using the formula below. This seems to generate the correct formula for the first first Pass Column, but inexplicably,
it shows the same percentage for all the other columns too? Thought you might be able to identify where I'm going wrong?
% of Total = CALCULATE(COUNT(ESI_CATEBI[Pass]), ALL(ESI_CATEBI))/CALCULATE(SUM(ESI_CATEBI[Pass]), ALL(ESI_CATEBI))
Greg, greatly appreciated. After working with the concepts you presented, I've ended up here, and this is about as close as I've gotten, but still not quite right.
Basically, I want to Divide the totals of the columns (e.g. Column 1 (24399)/Total/109365)
% of Total = CALCULATE(COUNT(ESI_CATEBI[Pass]), ALL(ESI_CATEBI))/CALCULATE(SUM(ESI_CATEBI[Pass]), ALL(ESI_CATEBI))
This seems to generate the correct percent for the first column, but it repeats the same percentage for all the other columns as well (instead of calculating new ones. Thought you might be able to help identify the problem?
Greg, greatly appreciated. After working with the concepts you presented, I've ended up here, and this is about as close as I've gotten, but still not quite right.
Basically, I want to Divide the totals of the columns (e.g. Column 1 (24399)/Total/109365)
% of Total = CALCULATE(COUNT(ESI_CATEBI[Pass]), ALL(ESI_CATEBI))/CALCULATE(SUM(ESI_CATEBI[Pass]), ALL(ESI_CATEBI))
This seems to generate the correct percent for the first column, but it repeats the same percentage for all the other columns as well (instead of calculating new ones. Thought you might be able to help identify the problem?
Greg, greatly appreciated. After working with the concepts you presented, I've ended up here, and this is about as close as I've gotten, but still not quite right.
Basically, I want to Divide the totals of the columns (e.g. Column 1 (24399)/Total/109365)
% of Total = CALCULATE(COUNT(ESI_CATEBI[Pass]), ALL(ESI_CATEBI))/CALCULATE(SUM(ESI_CATEBI[Pass]), ALL(ESI_CATEBI))
This seems to generate the correct percent for the first column, but it repeats the same percentage for all the other columns as well (instead of calculating new ones. Thought you might be able to help identify the problem?