Forum Discussion
One to Many relatioship
Hello everyone,
i have #incident AA* & Problem Start Date columns from Close table i have created a calender table with below dax
Calendar_Table = CALENDAR(MIN('Close table'[Problem Start Date]),MAX('Close table'[Problem Start Date]))
i have defined relationship one to many (calendare_table to Problem Start Date )
When i have created clustered column chart with Calendar_table(date) in Axis and count of Close table #incident AA* column in axis i am getting below chart which is showing a wrong number
Insted of i have deleted the Calendar_table and created same visual with
Close table [Problem Start Date] column in Axis and Close table count of #incident AA* in axis i am getting correct number. my one to many relationship is throwing wrong number