Forum Discussion

Souvik0812's avatar
Souvik0812
Frequent Visitor
3 years ago

Values in multiple columns of one table to reference and sort themselves by a column in another tabl

I have a Project table which looks like this: Project id   Overall RAG   Fin RAG   Bud RAG   Sch RAG Project-1 Red Red Green Amber Project-2 Grey Amber Grey Red Project-3 Gr...
Need Help
JFarq's avatar
JFarq
Icon for Helper I rankHelper I
3 years ago

Did you find a solution for this?

I have a similar issue.

I'm trying to sort the survey questions responses in matrices in a specific order (Strongly Agree, Agree, Neither agree nor disagree, disagree, strongly disagree) using a single table as a reference for multiple questions/fields:

I've tried using the following measure Activity is meaningful sort by 2 (based on this question solution)

 

Activity is meaningful sort by 2 = 
CALCULATE (
    SELECTEDVALUE ( LikertResponseOrderConnect[Name Order Index] ),
    CALCULATETABLE(
        MasterWithValidEntries2,
        USERELATIONSHIP ( MasterWithValidEntries2[Activity is meaningful], LikertResponseOrderConnect[Likert Question Response] ),
        ALLEXCEPT(LikertResponseOrderConnect, LikertResponseOrderConnect[Likert Question Response])
    )
)

 


It creates the new column with associated reference numbers:


But I get a circular dependency error message when I try to sort my Activity is meaningful survey question responses field by this new column.

 

Is there a way of doing this without having to create a separate table for each survey question response field?

Thanks for reading.