Trying to create a simple measure of Projects per Staff numbers
Sorry, this is first time posting. I am a self taught PowerBI dashboard creator and I am trying to create a simple 'projects per staff number' calculation for my companies dashboard. I feel it should be easy but the numbers keep being wrong, any help would be greatly appreciated, it's been quite frustrating. Details below. The Data: I have two sources of data. A Direct Query into a SQL database (DATA1) that lists all projects, with columns for Department etc. and a spreadsheet (DATA 2) with a column for department and staff numbers. The solution: I want to create a new measure of projects per staff numbers (PPP) and have tried creating a new measure under the spreadsheet data source with code along the lines of: Projects per Person (PPP) = VAR Depart_Project_Count = COUNTAX(FILTER(DATA1[ProjectType]="PROJECT"),DATA1[Department]) VAR Staff_Count = COUNTAX('DATA2','DATA2'[Department]) RETURN ( Depart_Project_Count / Staff_Count ) No errors are produced when I run it but gets the numbers wrong, see table belwo: For Glasgow the number PPP should be 3.14 ish (44/14) no 22. Any help or pointers would be greatly appreciated. Thanks
