Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, I need to calculate the Median / Day / DM Name for the NB_parcels it's possible to created a dax formula ?
@Vanessa250919 , Assuming NB_parcels is a measure, else create a measure
Try like
MEDIANX(summarize(Table, Table[Day], Table[DM Name], "_1", [NB_parcels]), [_1])
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
39 | |
20 | |
12 |