Forum Discussion
DAX Importing Measures from tabular server into table
Thank you for your response.
I have revised what I would like the table to look like so you can better understand:
| Year | Total Sales (Jan - Jun) |
| 2023 (TY) | 3875 |
| 2022 (LY) | 4185 |
Ideally, I would also like an expanded version of it showing month by month:
| Year | Jan Sales | Feb Sales | Mar Sales | Apr Sales | May Sales | Jun Sales | Total |
| 2023 (TY) | 500 | 450 | 600 | 700 | 725 | 900 | 3875 |
| 2022 (LY) | 550 | 425 | 610 | 750 | 750 | 1100 | 4185 |
More background:
This is all coming from one main table via one tabular data connection. There is no PBIX file as of yet, I am conceptually constructing this in DAX Studio to check for errors and once I have a solution I will begin building visuals and a data model in Power BI. This is one element that is ultimately going to be part of a larger report that is currently 100% Excel driven.
Measures:
This has been my main obstacle. I don't understand why these measures are loading so differently than the other table values. I have spent hours of reading documentation and searching forums.
| Measure Name | Type | Description |
| [Sales Dollars] | 1.2 Double | returns sales with or without a year parameter |
| [Sales Dollars LY] | 1.2 Double | reuturns sales dollars ONLY when a 'Calendar' field with a year is input i.e. 'Calendar'[Year Number] = 2023 wil return 2022 sales and 'Calendar'[Month Name/Year] = "January 2023" will return Jan '22 sales. |
Filters:
| Name | Type | Description |
| 'Calendar'[Year Number] | Int | Returns year i.e. 2023 |
| 'Calendar'[Month Name/Year] | Text | Returns Month/Year i.e. "January 2023" |
| 'Transaction Category'[Transaction Category] | Text | Returns a category i.e. "Wholesale" |
| 'Transaction Type'[Transaction Group] | Text | Returns a type of transaction i.e. "Direct to Customer" |
| 'Transaction Type'[TT] | Text | Returns a subtype of transaction i.e. "Palletized" or "Shipping Container" |