Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a related problem when I perform a 20/80. Namely, the metrics I've created for it is as follows
test 2 =
var rankead = RANKX( ALLSELECTED( fac_purchases[description] ); CALCULATE( SUM( fac_purchases[total_cost] ) ) )
RETURN
CALCULATE( [total cost]; TOPN( rankead; ALLSELECTED( fac_compras[description] ); [total cost] ) )
test 3 = CALCULATE( [total cost]; ALLSELECTED( fac_purchases[description] ) )
test 4 = DIVIDE( [test 2]; [test 3] )
The problem lies in that if filter by product the metrica works perfectly, however, when I want to do it above all the list of articles tells me that there is not enough memory to perform the operation.
"The visual object exceeded the available resources. Try filtering to decrease the amount of data displayed. Try again later or contact technical support. Provide these details if you contact them."
Regards,
B. Estevez
Someone can help me?
Regards
User | Count |
---|---|
54 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
80 | |
57 | |
40 | |
19 | |
10 |