Forum Discussion
Measure does not displayed on Table Visual
I have this structure below. I calculated the:
Total Intakes as = DISTINCTCOUNT(Intakes[value.ticketnumber])
When I try to put these into a table to see the accuracy, I get this:
I have assumed, its because there is no relationship between the tables
I decide to create a relationship as shown below
my visual changes to this
Please can anyone help me with the solution. I would really appreciate it.
Note what i used to create the calendar table
in both tables you should have only the date, and you have the date + time, so it doesn’t work for you
create new columns in both tables only date = DATEVALUE([Date]) and bind them to this column
6 Replies
The problem is your column 'Intakes'[value.createdon] has a time along with the date so there are no rows that match in your date table because that is just a date, the time is always 12:00:00 AM in the calendar table. You need to remove the time from your 'Intakes'[value.createdon] column, then the relationship will work.
in both tables you should have only the date, and you have the date + time, so it doesn’t work for you
create new columns in both tables only date = DATEVALUE([Date]) and bind them to this column
try adding a new column to the calendar table(DateTable) Year Month= FORMAT ( [Date], "mmm yy").
and pull it into a matrix and remove the month number (Month)
