Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Evening,
Not sure if its a bug or not but here goes,
I have a Calculated table for Order Date information that uses the below code to generate the Order Dates table.
Date = DISTINCT(SELECTCOLUMNS(MainTable, "Order Date", MainTable[Order Date], "Month", MainTabke[Order Date].[Month]))
(Theres a few more columns in the live example for Month Number, year and year number)
But when the table is produced it get this summary at the bottom;
So i know there is 3598 rows with 3598 unique dates,
Then there is the sales table which also contains the a refference to the Order Date but when i create a relationship between the two tables i get the below error;
Yet we know they are unique, from the summary image so why am i seeing the error?
Thanks in Advance,
J
I would double check by adding 2 measures:
DC = DistinctCount(Date[Order Date])
R = CountRows(Date)
They should show identical values...
Certainly multiple BLANK rows is the most common issue...
Hi Josh,
Are you sure that you don't have any blank values in the column Order Date?
If one row in the table contains a blank value in the table it will still show same number of distinct values as number of rows. However the blank value will prevent you from creating the relationship with your other table.
Br,
Magnus
@Anonymous
Could you share the problematic pbix file? I'd inspect it and try to reproduce the issue.
Sorry due to the nature of the data i am running in Power BI i cant share the source PBIX,
Thanks,
Josh
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |