Is it possible to total a column in a Visualization of joined columns?

[Nigel-Comporium]

Hello, 

I'm new to PowerBI but I have a question that seems like it should be easy on the surface, but I can't figure it out.

TL;DR - Is it possible to total a column in a visualization based off of the visualization? 

I have 3 tables: 

• Profile
• User
• User License

The tables relationships are as follows: 

As you can see by the relationship model, the 'User' table is only connected to the 'User License' Table by the 'Profile' Table. The 'User License' table has a field named 'Estimated Cost' which is the cost of the License. I have created a visualization that shows the License Name (from the User License Table) and the Estimated Cost (from the User License Table) and then the rest of the fields are from the 'User' Table (i.e. - Name, Department, etc). I've blocked out the user data to show an example of the visual table for reference. 

I want to be able to show a sum of the Estimated Cost based on the values showing in the Visual Table. Is that possible? 

[Anonymous · Accepted solution]

Hi @Nigel-Comporium ,

Please try this measure:

total =
VAR _table =
    SUMMARIZE (
        'User',
        'User'[Name],
        'User'[Department],
        'Profile'[License],
        "cost", SUM ( 'UserLicense'[Estimated Cost] )
    )
VAR _result =
    SUMX ( _table, [cost] )
RETURN
    _result

See if helps.

Fixing Incorrect Totals Using DAX Measures In Power BI

If this doesn't work, please consider creating some sample data, which would be very useful. Thanks in advance!

How to provide sample data in the Power BI Forum

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Nigel-Comporium]

This is exactly what I needed. Thanks so much for your assistance!