Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ErickReris
Frequent Visitor

Same protocol but multiple rows

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:

ErickReris_1-1719232015783.png

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.

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

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.

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

2 REPLIES 2
MFelix
Super User
Super User

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.

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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

 

Thank you soo much @MFelix !!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors