Forum Discussion

Dimitris_Kats's avatar
Dimitris_Kats
Icon for Helper V rankHelper V
4 years ago

Simplify DAX formula

Hello Dear members. I have the following dax:   CALCULATE( Credit'[Overdue] , KEEPFILTERS( CALCULATETABLE( TOPN( 'Top Customers'[Value],'Credit', 'Credit'[Overdue], DESC ), ALLSELECTED() )))...
SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

Dimitris_Kats 
what is  'Top Customers'[Value]? a measure?
anyway try:
Measure =
CALCULATE (
    [Overdue],
    TOPN ( 'Top Customers'[Value], ALLSELECTED ( 'Credit' ), [Overdue], DESC )
)