Power bi

Question

Olá, como concorda o código abaixo para que eu retorne com todos os valores de recuperação? Na minha tabela Notas, estou tendo apenas um valor retornador, porem preciso que seja devolvido todos os valores correspondentes. https://drive.google.com/file/d/1KHLvrQ6W9HkBkhU_GfRO1GGz5kXr2O2e/view?usp=drive_link&nbsp;Recuperado =CALCULAR (&nbsp; &nbsp; SUMX (&nbsp; &nbsp; &nbsp; &nbsp; FILTRO (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NOTAS ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NOTAS [Dados do custo] = MAXX ( NOTAS , NOTAS [Dados do custo] )&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; SUMX (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTRO (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'RECUPERAÇÕES' ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'RECUPERAÇÕES' [NOTA] = NOTAS [Nota]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'RECUPERAÇÕES' [RECUPERADO]&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; ))

lbendlin · Answer

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

lbendlin · Answer

CALCULATE(VALUES(x))&nbsp; only works (in a quirky way) when x is a list with a single element.&nbsp; You should use other DAX code that is more resilient.

enovais · Answer

https://drive.google.com/file/d/1KHLvrQ6W9HkBkhU_GfRO1GGz5kXr2O2e/view?usp=drive_link&nbsp;

lbendlin · Answer

Link asks for access, please check.

enovais · Answer

Me desculpe, agora está liberado.

Forum Discussion

Power bi

8 Replies

Related content

Power Apps for Power Bi

Power BI License

power bi

Image display in Power bi report

Power Automate is free with Power BI Pro Licence