Measure doesn't calculate dinamically

Question

Hi guys,&nbsp;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.&nbsp;Download pbix file&nbsp;Tks!&nbsp;it is the Measure Code

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;&nbsp;Create these 2 measures&nbsp;Total Vendas Sum = SUM(Vendas[TotalVendas])&nbsp;RANKI = IF(NOT(ISBLANK([Total Vendas Sum])),RANKX (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALLSELECTED(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Vendas'[Grupo],Vendas[Nome Cliente]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Vendas'[Grupo] = MAX(Vendas[Grupo])&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE(SUM(Vendas[TotalVendas]))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;))&nbsp;&nbsp;Regards,Harsh NathaniDid I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Forum Discussion

Measure doesn't calculate dinamically

2 Replies

Related content

DAX Calculated Measure

Use a measure to dinamically change dates on other measures

DAX Measure for Ranking the valid rows and calculating the average rating

CREATE A DINAMIC CALCULATED MEASURE

Dinamic dax with filters