Forum Discussion
Dividing a number on a Visualization Table when the data is imported.
mwalden I don't think the import / not import is the issue here, but rather aggregate function or not.
You can't divide by a column within a measure without using an aggregate function.
Try the following measures:
Total Emails = SUM ( Fact[Emails] )
Total Headcount = SUM (fact[employee )
OR
Total Headcount = DISTINCTCOUNT (fact[employeeid] )
Total Emails per person = DIVIDE ( [Total Emails] , [Total Headcount] )
If that doesn't work, can you provide a screenshot of your model / relationships view please?
AllisonKennedy
OK so I am getting closer thanks to your help!!
Here is the issue now, I cannot get Total Headcount to match the correct headcount. I also can't get the fact to work for it.Here is what I have right now and it gives me too many headcount. SEe the table below that shows what the headcount should be.
This is what happens when I add fact to it:
The problem is that I have a a table that shows the headcount - can I create a measure that just outputs the numbers that are in the table???
Count gets me closer to the better number
mwalden - what's the 'Correct Headcount' coming from? Is it a column or measure? You should be able to use that in your divide.
The 'fact' was just my placeholder for the table name, so you can ignore that part of it- sorry for confusion.
