Forum Discussion
DAX 20/80
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
1 Reply
- CreiharFrequent Visitor
Someone can help me?
Regards