Forum Discussion

bestevez's avatar
bestevez
Icon for Helper I rankHelper I
7 years ago

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