Category displaying total value for all members of the group rather than individual values ...?

[Anonymous]

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

[Anonymous · Accepted solution]

Hi @Anonymous ,

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.

[PaulDBrown]

Can you show a depiction of the model (relevant tables) and post the code for the measures please?

[amitchandak]

@Anonymous , As per the second screenshot. The table having remaining hrs, do not have a relationship with current unit or the relationship is inactive

[Anonymous]

@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 ...