Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am making i Workforce report. Those I create the report for want to look at the average of the workforce based on the number of selected months (divide the workforce sum by the number of selected months in the dashboard). In other words, if months 1, 2 and 3 are chosen, the workforce must be divided into 3. If months 4,5,6 and 7 are chosen, the workforce must be divided into 4. If only January is chosen, the workforce must be divided into 1, and so on.
Do someone know if this is possible?
Solved! Go to Solution.
Hi @herwet ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want. You can create a measure as below to get the average of workforce base on the selected months:
Average of workforce =
VAR _countofselmonth =
CALCULATE ( DISTINCTCOUNT ( 'Date'[Date].[Month] ), ALLSELECTED ( 'Date' ) )
RETURN
DIVIDE ( SUM ( 'Table'[Workforce] ), _countofselmonth )
Best Regards
Hi @herwet ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want. You can create a measure as below to get the average of workforce base on the selected months:
Average of workforce =
VAR _countofselmonth =
CALCULATE ( DISTINCTCOUNT ( 'Date'[Date].[Month] ), ALLSELECTED ( 'Date' ) )
RETURN
DIVIDE ( SUM ( 'Table'[Workforce] ), _countofselmonth )
Best Regards
@herwet , In case you have a date table with month year
count of selected months
countx(summarize(allselected('Date'[Month Year])), [Month year])
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |