Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I got stuck, so I would greatly appreciate your wisdom.
I am trying to create a metric TREND as a calculated column so i can create a filter later from it. It works well as a measure, but no filter can be created from it. To calculate TREND i am using two calculated columns VisitCount Yesterday and VisitCount All Previous Days (sum of all visits from the start date)
TREND = VisitCount Yesterday / VisitCount All previous days
VisitCount Yesterday = CALCULATE ( SUMX('Table(2)'[Visits]), 'Table(2)'[VisitDate] >= TODAY()-1 ) VisitCount All previous days = CALCULATE( SUMX('Table(2)','Table(2)'[Visits]) , ALLEXCEPT('Table(2)', 'Table(2)'[FaId]))
Trend ='Table(2)'[VisitCount Yesterday]/'Table(2)'[VisitCount All Previous Days]
Calculated columns are ok, but when divided, I got an error of Circular dependency:
Do you have any idea how to solve it?
Solved! Go to Solution.
Thanks, Prateek!
I realise that this problem is solved by creating calculated table (including only yesterday values) to avoid having emtpy rows. Apparently they were the sourcse of circular dependency. It works well now. Thanks 🙂
Thanks, Prateek!
I realise that this problem is solved by creating calculated table (including only yesterday values) to avoid having emtpy rows. Apparently they were the sourcse of circular dependency. It works well now. Thanks 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |