Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have 2 Tables:
1) Date
2) Employee_Info
'Date' master table is connected with Employee_Info.
I have created one table visualization inside Employe_Info.pbix file. Table is filter with Year.
1) Inside Employee_Info.pbix "Fiscal Month" is taking from Date table, after that I created one Measure with name "#Count Employee" which calculate total 'Count of Employee' column.
#Count Employee = CALCULATE(SUM(Employee_Info[Count of Employee]))
2) After that I created Measure with name "Rank of Employee" Which is getting rank of Employee based on fiscal Month.
Rank of Employee = if([#Count Employee]>0 || [#Count Employee]<>BLANK(),RANKX (FILTER(ALLSELECTED('Date'[Fiscal Month]),[#Count Employee]<>0 || [#Count Employee]<>BLANK()), [#Count Employee],,ASC,Dense))
3) Finally I am calculating 'Median' of "#Count Employee" for that I have created Measure with name "Median_of_Emp" with couple of steps followed inside "Median_of_Emp" Measure.
Median_of_Employee =
******Now I am not getting correct value 63.64 or Roundup 64 for "Median_of_Employee" Measure. How to get correct value in Median_of_Employee Measure.
Below I am showing image:
@Mariusz any Idea about it.
Solved! Go to Solution.
Hi @mohittimpus
Please see the below calculation result of a Median function in Excel based on this sample.
Hi @mohittimpus
Please see the below calculation result of a Median function in Excel based on this sample.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |