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.
Good day,
I am doing a pareto analysis with different Pareto variables.
I am not using the cumulative $ for the Pareto, but mostly the frequency (number of hits) on the items.
Here is the Table
Classe | Criteria |
A | 12 |
B | 9 |
C | 6 |
D | 3 |
E | 0 |
Where A is the number of hits that qualifies the item to be in class A.
As the classes are not related in my table, this would be some set variable in Power BI.
Is there anyway (as I would do in Excel) to say; If # hits is higher than A (12), then it is an A, if not, then if it is higher than B (9), it is a B... and so on.
I would also like to be able to have this table in my dashboard and change the parameters to see the impact on my charts.
Thanks
Solved! Go to Solution.
HI @Anonymous,
You can refer to below formula to get correspond class based on your logic.
Calculate column in records table.
Type = VAR variable = CALCULATE ( MAX ( Reference[Criteria] ), FILTER ( ALL ( Reference ), [Criteria] <= Records[Amount] ) ) RETURN LOOKUPVALUE ( Reference[Classe], Reference[Criteria], variable )
Notice: Reference table is the sample table, Records table stored index and amount columns.
Regards,
Xiaoxin Sheng
HI @Anonymous,
You can refer to below formula to get correspond class based on your logic.
Calculate column in records table.
Type = VAR variable = CALCULATE ( MAX ( Reference[Criteria] ), FILTER ( ALL ( Reference ), [Criteria] <= Records[Amount] ) ) RETURN LOOKUPVALUE ( Reference[Classe], Reference[Criteria], variable )
Notice: Reference table is the sample table, Records table stored index and amount columns.
Regards,
Xiaoxin Sheng
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |