Forum Discussion
Same protocol but multiple rows
Hi ErickReris ,
In this case you can go with different approachs but without making model changes the option is to create some measures for this they should be similar to this:
Total Nota Final = SUMX(SUMMARIZE(Table, Table[Nro. Protoolo], Table[Valor Total Nota Fi]),Table[Valor Total Nota Fi])Since the values for the Protocol is always the same this will give you a table with a line value for each protocol and without repeating the value several times.
Now you can use this metric on your visualization and calculations.
If you are looking for an average value you should use AVERAGEX instead of SUMX. For the number of protocols you just need to use a DISTINCTCOUNT for example.
Hi ErickReris ,
In this case you can go with different approachs but without making model changes the option is to create some measures for this they should be similar to this:
Total Nota Final = SUMX(SUMMARIZE(Table, Table[Nro. Protoolo], Table[Valor Total Nota Fi]),Table[Valor Total Nota Fi])
Since the values for the Protocol is always the same this will give you a table with a line value for each protocol and without repeating the value several times.
Now you can use this metric on your visualization and calculations.
If you are looking for an average value you should use AVERAGEX instead of SUMX. For the number of protocols you just need to use a DISTINCTCOUNT for example.
