Adding details in rows

[KevinSV]

Hello everyone, I have a little question about my report on Power BI Desktop. 
Actually I create a table where I add a column named HT which has the amount by invoices. 
In my example, I have 3 lines like this in my server : 

But the problem is that Power BI automatically cancel the 2 first line with the same invoice (A) like this : 

I don't want the sum in my rows but only in my total like when i don't summarize the column like this : 

But i need the total. 
Is that possible to create a measure or column which can show me all the details like the don't summarize and the total like the sum ? 
Here is a recap : 

Thank you ! 

[v-kpoloju-msft · Accepted solution]

Hi @KevinSV,
Thank you for reaching out to the Microsoft fabric community forum. Thank you @bhanu_gautam, for your inputs on this issue.

After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used it as sample data on my end and successfully implemented it.

Please try this measure for creating Total_HT column. I have tried with some sample data in my end, it worked fine:

Total_HT = SUM('SampleData'[HT])

I am also including .pbix file for your better understanding, please have a look into it:

I hope this could resolve your issue, if you need any further assistance, feel free to reach out. If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

[KevinSV]

Hello @v-kpoloju-msft thanks for your reply ! 

Do you have any idea to hide the column without the total and without changing the details values ? Because when I remove it, the table does automaticly the sum ang give me one row of A invoice with 0 in HT column. 
Thanks again for your reply 🙂 ! 

[bhanu_gautam]

@KevinSV Go to the "Modeling" tab and click on "New Measure".
Define the measure to calculate the total sum of the HT column.

TotalHT = SUM('YourTable'[HT])

In your table visual, add the HT column.
Click on the dropdown arrow next to the HT column in the Values section.
Select "Don't summarize".

Add the TotalHT measure to your table visual to show the total sum.

[KevinSV]

hello @bhanu_gautam, thanks for your reply. Do you know if I can hide the column HT which is summarize ? Actually I have this visual : 

Do you know if it is possible or not to hide the HT column without changing the details in the rows ? 
Thanks again for your reply !