Getting error while trying to display the multiple selected values of slicer in a card.

[SaiKrishna007]

Getting "Column is part of composite key, but not all columns of the composite key are included in the expression or its dependent expression" while trying to display the multiple selected values of slicer in a card.

[Logan_404]

Hii @SaiKrishna007 what solution did you find for the above problem?

[Anonymous]

Hi @SaiKrishna007 ,

Base on the error message, it seems that the table use a composite key. And the column [State_Code.State_Code LEVEL01] is a part of composite key, you need to ensure that all columns of the composite key are included in the measure's expression for resolving the problem. Could you please provide the formula of measure 'Charged off Account Report'[State_Header] and which columns be included in the composite key? It will be helpful to find the solution. Thank you.

Best Regards