cancel
Showing results 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

Frequent Visitor

## Wrong total amount

I am creating a measure like this

[Un-Allocated]*[SalesUnitPrice test]
it's number of ordrer multipy with unit price  in subtotal I am getting wron number becuase
it ganna multipy  sum([Un-Allocated]) * sum ([SalesUnitPrice test]) and I don't want it I don't know how can I resolve this ?
1 ACCEPTED SOLUTION
Anonymous
Not applicable

I think you have a few options with this.  You can perform the calculation as a calculated column.  For every Row Un-Allowcated * SalesUnprice.  Then simply wrtie a measure for that calculated column.  Or you can use SUMX.

That would look like the following..  SUMX( <Table>, UnAllocated Column * SalesUnit Price)

This sumx will iterate through the granularity put in table.  It can be very expensive if your fact table is very large, if that is the case I recommend performing a calculated column.  The X functions are great when you create a small summarize/filtered list that should need to be itterated through.  Try getting close and post if you don't get it.  Also if need help implementing please publish the tables and relationships needed for this measure.

Anonymous
Not applicable

I think you have a few options with this.  You can perform the calculation as a calculated column.  For every Row Un-Allowcated * SalesUnprice.  Then simply wrtie a measure for that calculated column.  Or you can use SUMX.

That would look like the following..  SUMX( <Table>, UnAllocated Column * SalesUnit Price)

This sumx will iterate through the granularity put in table.  It can be very expensive if your fact table is very large, if that is the case I recommend performing a calculated column.  The X functions are great when you create a small summarize/filtered list that should need to be itterated through.  Try getting close and post if you don't get it.  Also if need help implementing please publish the tables and relationships needed for this measure.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors