Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Have the following
sales table with date on it
calendra table with date on it.
Calnedra has an entry for every date whereas sales has an entry only if sales on those dates.
tables linked on dates but calendar pulling back all rows.
How can we ensure only calendar rows with sales data are retrieved or filter out all rows from calendar with no sales data.
No inner join box on relationships setup.
Thanks
Solved! Go to Solution.
Hi @po
You may create relationship between the two tables as below. Then drag the calendar date column and sales data in one visual.
Regards,
Cherie
Hi @po
You may create relationship between the two tables as below. Then drag the calendar date column and sales data in one visual.
Regards,
Cherie
Thanks for replies.
Hi @po
There is no INNER JOIN option. When you drop a measure which doesn't return any data (blank) the dimenion rows will be automatically filtered out
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Can you give some more information on how you are using the calendar and sales tables in a visual or in DAX? I have data with sporadic dates and cannot reproduce what you are describing.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |