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.
You could help me with the following scenario.
I have an array and make a custom subtotal for each row.
In the example, I need the headcount to be the average of the months, the admission is only the last month, and the turnover is the sum of the months.
Follow the link for the sample pbix.
Thank you very much
Solved! Go to Solution.
@tarocha , Assuming these 1,2,3,4 are month no
Try new measures like
averageX(values(Table[Month no]), [Headcount])
calculate([admission], filter(allselected(Table), Table[Month no] = max(Table[Month no] )))
or you can is filtered and push this calculation to grand total
refer:https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
@tarocha , Assuming these 1,2,3,4 are month no
Try new measures like
averageX(values(Table[Month no]), [Headcount])
calculate([admission], filter(allselected(Table), Table[Month no] = max(Table[Month no] )))
or you can is filtered and push this calculation to grand total
refer:https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
@amitchandak
Thanks your guidance has guided me to find the way to do the calculations.
Thank you!
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |