topic Re: Measure doesn't calculate dinamically in DAX Commands and Tips

Measure doesn't calculate dinamically

Anonymous — Tue, 26 May 2020 21:50:42 GMT

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

Re: Measure doesn't calculate dinamically

Anonymous — Tue, 26 May 2020 22:37:54 GMT

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)

Re: Measure doesn't calculate dinamically

Anonymous — Wed, 27 May 2020 01:50:10 GMT

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