Forum Discussion

oriabbhou1's avatar
oriabbhou1
Frequent Visitor
5 years ago
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...
iXpert_info's avatar
iXpert_info
Icon for Helper II rankHelper II
5 years ago

Hey oriabbhou1 

I'd Suggest you to create a Calculated column for your solution

column=divide(table[LessonCount],table[RequiredLesson],0)

if you dont want to use above solution can you please share some sample data

Did I answer your question? If Yes, Please mark this as a solution

Best Regards
Jay Patel
iXpert Analytics

oriabbhou1's avatar
oriabbhou1
Frequent Visitor
5 years ago

Hi iXpert_info & Anonymous ,

 

I tried creating a calulated column but the required lessons column from the lessons required table is not popping up as the denominator. 

Both columns are whole numbers so i dont see why it shouldnt work. I'm pretty much trying to accomplish the % completion colum in the sample data below.

 

Here's my sample data below: