DAX 20/80

bestevez — Wed, 05 Jun 2019 09:01:00 GMT

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

Re: DAX 20/80

Creihar — Fri, 07 Jun 2019 09:08:11 GMT

Someone can help me?

Regards

topic DAX 20/80 in DAX Commands and Tips

DAX 20/80

Re: DAX 20/80