Can't sort from custom index column

Settha — Wed, 24 Nov 2021 04:27:46 GMT

I have data column as "Sale State". In the visualize I want to sort

- Qualify 10% = 6
- Develop 20% = 5
- Solution 40% = 4
- Proof 60% = 3
- Close 80% = 2
- Invoice 100% = 1
- Lost 0% = 7

I create custom colum as "Sale State Index" and sort "Sale State" from "Sale State Index" but the Power BI show error "Filed to save modifications to the server. Error returned: A circular dependency was detected"

Please help me fix this error.

Re: Can't sort from custom index column

VahidDM — Wed, 24 Nov 2021 04:54:27 GMT

Hi Settha

That error is because those the Sale State Index is related to Sale State, Try to add the Sale State Index column in Power Query rather than DAX.

Or create a table with dax by using ADDCOLUMN and VALUES([Sale State]) dax functions then relate a new table with the main table, and use Sale State column from a new table in your visuals.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

topic Can't sort from custom index column in DAX Commands and Tips

Can't sort from custom index column

Re: Can't sort from custom index column