Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Circular Dependency using Selectcolumns

Good morning community,   just wondering if you could help me with the following.   I have created a few calculated columns and the value is used as conditional formatting as per below.   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you for your reply.

 

The solution you provided is my current situation.

What I need is to be able to filter the table by selecting values from the piechart.

 

Regards,

v-kkf-msft's avatar
v-kkf-msft
Community Support
5 years ago

Hi Anonymous ,

 

Try the following formula:

Filted Row = 
var BigStage = 
    CALCULATETABLE(
        VALUES('Table'[Big 5]),
        'Table'[Big 5] = "Yes"
    )
var TraStage = 
    CALCULATETABLE(
        VALUES('Table'[Big 5]),
        'Table'[Big 5] = "No",
        'Table'[Transport Required] = "Yes"
    )
return 
    IF(
        SELECTEDVALUE('Calculated Table'[Stage]) = "Big 5",
        COUNTROWS( INTERSECT( BigStage, VALUES('Table'[Big 5]) ) ),
        COUNTROWS( INTERSECT( TraStage, VALUES('Table'[Big 5]) ) )
    )

 And put the measure into Big 5 field:

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.