Forum Discussion
Anonymous
7 years agoNot applicable
I need Help
FUND-PADRAO =
[PES_CTBIL_CORRI dividido por Mil] * MAX('Padrao-17'[Especificacao])
I need just calculate the SUM of measure FUND-PADRAO.
https://uploaddeimagens.com.br/imagens/capturar-png-6eaa1456-c5ee-450a-a4cd-fef079080c7e
Thanks !
- Anonymous7 years ago
I managed to solve my mistake.
Thanks to everyone
4 Replies
- StachuCommunity Champion
you can use SUMX and SUMMARIZE
e.g. like here, you just need to adjut the red syntaxMeasure = SUMX ( ADDCOLUMNS ( SUMMARIZE ( Table, Table[Column1], Table[Column2] ), "Val", [FUND-PADRAO] ), [Val] )- AnonymousNot applicable
I don't understand...
Can you help me ?
My project > https://drive.google.com/open?id=14ZA_tbMp1Ca8jAGh_DEJ1cCW91O2-KZX
- v-jiascu-msftMicrosoft Employee
Hi Anonymous,
I have requested the access to the file. Please kindly grant the permission if you can. Please don't post sensitive data in the community, which could lead data leak.
Best Regards,
Dale