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,
Both new to the community and the Power BI tool! Have created a couple of basic reports and was recently asked to add a further category (just about the time of the Sept update) and I've gone from diagram one to diagram two! Am stumpted as to what needs to be updated to correct this ...
... I've checked all the relationships, restarted the entire report, double checked the originating data. Any assistance would be most appreciated.
AngusM - Oxford University Hospitals UK
Solved! Go to Solution.
Hi @AngusMOUH ,
Is Remaining (Hrs) a measure, a column or a calculated column? If it is a measure or calculated column, it may be because your function is used incorrectly.
Example:
Measure = CALCULATE(SUM('Table'[Value]),ALLSELECTED('Table'))
You should use ALLEXCEPT instead.
Measure = CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[ID]))
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @AngusMOUH ,
Is Remaining (Hrs) a measure, a column or a calculated column? If it is a measure or calculated column, it may be because your function is used incorrectly.
Example:
Measure = CALCULATE(SUM('Table'[Value]),ALLSELECTED('Table'))
You should use ALLEXCEPT instead.
Measure = CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[ID]))
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Can you show a depiction of the model (relevant tables) and post the code for the measures please?
Proud to be a Super User!
Paul on Linkedin.
@AngusMOUH , As per the second screenshot. The table having remaining hrs, do not have a relationship with current unit or the relationship is inactive
@amitchandak thank you for that, much appreciated. All relationships are based on the staff ID numbers that are unique identifiers and are contained in all the table extracts ...
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |