Forum Discussion
How do I calculate specific Rows that are created by other measures
I am still pretty new at Power BI. Basically I have the table below
| Line Item Description | Month | Plan | Last Year Month |
| Total Sales: | |||
| Sales | xxxx | xxxx | xxxx |
| Freight Billed | xxxx | xxxx | xxxx |
| Gross Sales | |||
| Cost of Sales: | |||
| Standard | xxxx | xxxx | xxxx |
| Freight Cost | xxxx | xxxx | xxxx |
| Manufacturing Costs | xxxx | xxxx | xxxx |
| Gross Cost |
I use 3 measures to come up with the Month/Plan/Last year Month columns to get all of my data into the table
Month = CALCULATE(
SUM('GELMAS'[Month Total]),
INTERSECT(
VALUES('GELMAS'[Group Number]) , VALUES('Income Statement Template'[Group Number])
)
)
I do the same for both Plan and Last Year Month.
I do the same for both Plan and Last Year Month.
My question is what would be the best way or how would I go about adding the values that are created from the measures to get my gross sales and gross cost?
Gross Sales would be Sales + Freight Billed
Gross Cost would be -Standard -Freight Cost - Manufacturing Costs
Any help would be greatly appreciated!
1 Reply
That's not a data format you would want to use in Power BI. Unpivot your data to make it more usable.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
