- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Wrong total amount
I am creating a measure like this
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
12-11-2024 04:50 AM | |||
12-03-2024 03:57 PM | |||
08-26-2024 08:05 PM | |||
10-04-2024 06:07 AM | |||
01-20-2025 06:01 AM |
User | Count |
---|---|
14 | |
14 | |
11 | |
11 | |
8 |