Forum Discussion
Solved
Divide count distinct column by non calculated column
Hi, I'm doing a quick measure to divide 2 columns without doing any calculation on the denominator column. So here's the scenario: The numerator column(lesson count) does a count of lessons a...
oriabbhou1 try the following
% Completion = DIVIDE('Lessons(SQL Table)'[Count of Lesson],RELATED('Lesson Required Table'[Lesson Required]))I've added a PBIX file to this one drive link that shows how I achieved it for you.
oriabbhou1 try the following
% Completion = DIVIDE('Lessons(SQL Table)'[Count of Lesson],RELATED('Lesson Required Table'[Lesson Required]))
I've added a PBIX file to this one drive link that shows how I achieved it for you.
This worked Perfect. Thanks soo much Anonymous