Forum Discussion

dbobonec's avatar
dbobonec
Frequent Visitor
5 years ago
Solved

Table with an explicit total column

Hi,   I'm struggling with the following problem: I need to create a table in Power BI Desktop that give me a measure value (let's say capital) by ContractType and Bank, as the example below, but I ...
Need Help
  • dbobonec's avatar
    dbobonec
    5 years ago

    Hi v-easonf-msft,

    Thank you very much for your reply, for what I see from your pbix it will work for my example.
    I need to adapt it to my real problem, with higher complexity, but I will accept it as a solution!

    Thank you and regards, Diogo 

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi， dbobonec 

If you want to export the column subtotal in matix through "export data" in PowerBI Desktop, I am afraid that there is no corresponding solution yet.

You need to manually create an actual Total measure and apply it to the value of your matrix.

 

All Banks = CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[Bank]))

 

And you will find the total in the csv file you exported.

If I misunderstood, please let me know.

 

 

Best Regards,
Community Support Team _ Eason

dbobonec's avatar
dbobonec
Frequent Visitor
5 years ago

Hi v-easonf-msft,

Thank you very much for your reply, for what I see from your pbix it will work for my example.
I need to adapt it to my real problem, with higher complexity, but I will accept it as a solution!

Thank you and regards, Diogo