Measure doesn't calculate dinamically

[Anonymous]

Hi guys, 

I created a measure and it should be calculated a RANKX dinamically in the visual when I change the slicer (date field) , however it is not work. Somebody can help me to solve this?

I attached a pbix file with an example. Download pbix file 

Tks!

it is the Measure Code

[harshnathani · Accepted solution]

Hi @Anonymous ,

Create these 2 measures

Total Vendas Sum = SUM(Vendas[TotalVendas])

RANKI =

IF(NOT(ISBLANK([Total Vendas Sum])),

RANKX (

        FILTER(

            ALLSELECTED(

                'Vendas'[Grupo],Vendas[Nome Cliente]),

            'Vendas'[Grupo] = MAX(Vendas[Grupo])

            ),

            CALCULATE(SUM(Vendas[TotalVendas]))

            ))

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

That's all Harsh, tks a lot for your help. It worsk!!!