Clustered column chart as a percent

[corwa]

I have table with student responses in power BI. A row consists of semester, Course, Program, Department, Instructor and student response (Always, Frequently e.tc)

I would like to create a stacked (not 100%) column chart based on percentages.
for example: For each semester code (124,145) when a user makes a selection on any of the slicers, I should get the proportion of each response as % of semester Total.
I created a
Measure= DIVIDE(CALCULATE (countrows (fact_table[response])),
CALCULATE (countrows (fact_table[response]),ALLEXcept(semester, course, program, department, instructor)).
It produces wrong results when some slicers are not selected.
My slicer are semester, course, program, department, and instructor
I would highly appreciate some help

[Anonymous]

Hi @corwa ,

Can you share a sample file with us and show us a screenshot with the result you want? This will make us easier to find the solution.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[corwa]

My measures are:
1) All_counts = COUNTROWS(fact_table) -- ALL counts
2) all_dept_Total = CALCULATE([All_counts],ALLEXCEPT(fact_table,dim_entity[Fk_grp]))
3) percentage_count_by_dept = DIVIDE(CALCULATE([All_counts]),CALCULATE([all_dept_Total]))

[corwa]

Sure
I would like to re-generate chart  A (100% stacked column chart)
using  calculated measure ( using allexcept/any other function) to get chart B under any combination of slicers.
Would like to re-generate A using a measure

[corwa]

Hi Rico

How do I share this sample file?