Same protocol but multiple rows

[ErickReris]

Hi guys, i may need your help with one question.

I have a table called Protocols that allow me to see the number of the protocol, the value in $ and the itens.

And for each protocol, i have the full value of the Fiscal Note.

But i'm having a problem, that each protocol repeats in the table because the itens are different, but the full value of the protocol is the same. 

I will send an example:

The value of the fiscal note is the same, but the itens are diferent. 

The protocol can repeat more than 2 rows.

How can I consider a single invoice value even if it is repeated several times?

So in the graphs, the value will not be doubled, tripled or even more.

[MFelix · Accepted solution]

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.

[ErickReris]

The dax measure that you sent give me the result that i expected !!

Thank you soo much @MFelix !!