you are not only a PBI master, you are a mind reader as well . I had to get some work done and was hitting exactly the circular dependency scenario when creating a bridge table - this technique saved me tons of hours of research - THANK YOU !!! Grazie caro!!!!
Thank you so much for your explanation! You've helped me a lot. I was stuck on this circular dependency problem and your video was the only one that really helped me to solve it. From now on I'll make sure to properly set the "ALLEXCEPT" in all my "CALCULATE" functions. Keep doing your videos. Excellent content! Many thanks from Brazil (:
So not only are the SQLBI guys putting out great content, but now they are also mastering the art of the RU-vid thumbnail image 😀. Love the expression Alberto. Keep up the good work, we all benefit from it!
Thanks a lot for sharing this with us! I struggled to understand why my calculate table was not accepting the relationship. Now I understood. Thanks again!
Thank you so much for this. Just to help you in your English grammar since you helped me in my DAX, after "did" you need to put everything in past tense, so "is" becomes "was" and you also need to turn the gerund "creating" into the verb "to create." So instead of "What I did is creating a table" one says, "What I did was to create a table"
Amazing !! you wonderfully explained how to avoid Circular dependency, this helped me in many cases and to understand how Power BI deals with it in backend. Thanks a lot for the help !! :)
Amazing! I was struggling with this. I could not solve it, so I turned to SQL. Now I know. 😀 Just curious if you would use calculated table, whether that would be faster than using the filter function.
When I use ALLEXCEPT some of my data changed and 2 rows were removed from the calculation analysis. I dont know how to figure out what is right or wrong!
Hi, I am experiencing this error but didn't use the CALCULATE expression at all. This error came up when I try to create bins from a calculated column (percentage progress) by a measure divided by a measure. Can you please help?
Hi Alberto, I wonder what makes you good for the other ,i mean DAX make you good for chess game (I saw one behind you) or the opposite, but you have to choose one answer or it will be circular dependency🤣 great video, best continuation
I have a table created by CALENDARAUTO(12 as my fiscal year value) , I want to create separate column in the same table that returns "Year-Month" in format "2021-May". How can I achieve this through DAX ?
Pease can you help me with this situation: Daily balance = [Receive] + backlog - analyzed backlog = var previous balance = calculate ( [Daily balance], Dateadd( Calendar[Date], - 1, Day) ) return previous balance I tried multiple things but nothing worked. Calculate column's, measure, nothing worked
I get a ciruclar dependency that i do not understand. I want to create a relationship on a calculated table. I've simplified the Table as much as possible to exclude Issues and the Modell has no RI Violations, so no Blank Rows: CrossEmpl = VAR _Empl1 = SUMMARIZECOLUMNS( Employees[DAEmplID] , 'Date'[CY Month] -- this is to group by month (first date of Month) , "@CE Hours", [HP Hours] -- HP Hours = SUM ( HoursPosition[HP_Hours] ) ) RETURN _Empl1 If i want to create relationships with the Employee or Date Table i get this Errors: A circular dependency was detected: CrossEmpl[CrossEmpl-...guid..,ae4], ...guid...c62(*changing), CrossEmpl[DAEmplId], CrossEmpl[CrossEmpl-...guid...ae4]. A circular dependency was detected: CrossEmpl[CrossEmpl-...guid..,ae4], ...guid...09c(*changing), CrossEmpl[CY Month], CrossEmpl[CrossEmpl-...guid...ae4]. * changes with each try If i replace Employees[DAEmplID] by HoursPosition[DAEMPLID] i can create the Relation. But for Date this is not possible as i want to group by month. Any Ideas why this is causing a Cirular Dependency: My Idea is now to duplicate the Date Table and use the Related Columns and not the Related Table, but i do not like this. Other Idea is to add year and month or Month (First Date of month) as Columns to my Source Table. But i would need to to this for three tables... select DATABASE_NAME, TABLE_ID, ROWS_COUNT, RIVIOLATION_COUNT from $SYSTEM.DISCOVER_STORAGE_TABLES WHERE RIViolation_Count > 0 => Nothing
If you are creating the Date table with a calculated table, it could be that one of the columns of the new calculated table has a date data type.
3 года назад
@@SQLBI No, Date Table is imported from my SQL Database. I just realized that DAX doesn't know date (only DateTime) even that i've cast all Dates to Date. But Problem is also with my DAEmplId (Dataarea Employee ID). Again: If i replace DAEmplId with the Key Column on the Fact table it is working. But if i use the Dimension Table this Error is caused.
Please, try to reproduce the problem with the data model of the article and write a comment in the article if you can do that, otherwise it's impossible to analyze the problem in more detail. Thanks!