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.
So I have a table that is structured as follows :
Customer | Category | Time | Summary |
Cust A | Cat1 | 3 | Something |
Cust B | Cat2 | 1 | Something |
Cust A | Cat 2 | 2 | Something |
All Cust | Cat1 | 2 | Something |
Basically I have a new line each time I do a task for one of my customers (how long I've been on it and in which category it belongs).
When I do a task that benefits all my customer (ie : internal training etc) I give it the customer name of "ALL Cust" and specify a category.
What I need is, when visualising my data in anytype of visualization that implies the time spent per categories, that this "All customer time" to be evenly distributed amongs all other customer based on the category ...
Do you guys have any idea if it's possible to do that DAX ? I've thought about using the FILTER function but couldn't find anything ...
Hi @Anonymous ,
We can get the time spent per categories by the following measure.
Measure = CALCULATE(SUM(Table1[Time]),ALL(Table1),VALUES(Table1[Category]))
Please check the pbix as attached. If I misunderstand you, please share your excepted result to me.
Regards,
Frank
Hi, So it isn't exactly what I need, what I want is for the "All Cust" time to be distributed to the SUM of time of EACH other customer based on the category so that at the end I have something like this :
All Cust Cat1 Time = 2
ALL CustA Cat1 time = 3+((All Cust Cat1 Time)/(Number Of Cust)) which here = 3+1 = 4
ALL CustB Cat1 time = 0+((All Cust Cat1 Time)/(Number Of Cust)) which here = 0+1 = 1
ALL CustB Cat2 time = 1+((All Cust Cat2 Time)/(Number Of Cust)) which here = 1+0 = 0
Still searching for a way to do it ... I've found a way to sum it and distribute it WITHOUT keeping the category or to sum the category but WITHOUT being able to distribute it ...
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |