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.
Hello,
I have the below data displayed for 3 consecutive months (NND, NND-1, NND-2).
NND for single period calculates as "Availability"/"Client" and results either 0 or 100.
Subtotal result is equal to positive evaluated clients / all evaluated clients. For instance "NND-2" = 7/8=88.
NND for three periods together calculate the same way with only difference "If at least once in last three periods Availability is positive then result is positive"
I calculated the "Availabilty 3M" as follows
The problem is I do not receive a subtotal for Availability 3M (in this case 11) but 1 according to sum if function.
Could anyone help to solve that? my expected end result would be:
Availabilty 3M = 11
Client 3M = 12
NND 3M Total =11/12 = 92
Thanks
Jordan
@jordanesqu , can you share formula
You have to try something like
sumx(summarize(Table,Table[Customer_Lv1,Table[Customer], "_1",[Availabilty 3M]),[_1])
Thanks for the tip. I have however more dimensions like region, sales manager, sales rep, material, customer and would like it work flexible depending on selection. in this case sumx did not work for me.
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 |
---|---|
44 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
70 | |
49 | |
45 | |
20 | |
16 |