Forum Discussion
Helper IHelp with a table visualization/DAX Query
Helper II believe they are set to SUM, however I've also tried selecting "Don't Summarize", and it still does not resolve the issue.
Memorable MemberIn your data table (not table visual) you need to review each column and assure that the column/field is the appropriate type. The symptoms you have are consistent with what one thinks is a number field but is actually in PBI as a text field. So you want to change/correct every field/column to be either text or number as they should.
Then in your table visual every thing should be able to be made to work. Be sure to select Unsummarize for the Year assuming it is a whole number, and potentially the same thing for the Order # unless that is text.
- mcray11
Thank you for the suggestion. I've checked the data types and they are all correct, either whole number, decimal number or date.
I'm still not able to display the proper Val in RC for that month/Order number-only a total-in both matrix and table visuals.
I've also reviewed the relationships and the tables are connected via two other connecting tables. Could that be an issue? I'm not getting an error but am not sure what else could be wrong.
- CahabaData
Val in RC would be the last measure to set up; leaving that out you have sum of Vehicles & Services by single month line okay?
What is the Val RC formula?
- mcray11
That is correct, the table displays correctly with the exception of the Val in RC column.
That column is not actually a calculated column, it is a sum of all values of one data type (selected via filter) from another column.
v-haibl-msftMicrosoft Employee
Could you please provide the relationship of these tables? And the answers to CahabaData’s questions are also needed.
Best Regards,
Herbert
- mcray11
Hi Herbert,
There are two intermediatry tables connecting the two data sources for this visualization.
Site>Locations>Order Numbers>Val in RC data
Thanks for any suggestions!