Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sort Order Impacting Measures

I have a dataset which has This Year and Year Ago data. I used a table to provide the sorting order for the same using a relationship and relation function. Post this I sorted TY/YA columns based on ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

I want to bring change the order of legends from TY/YA to YA/TY. Hence, I had used the re-ordering using a index column. However, as soon as I brought in the index column and sorted the TY/YA column basis index my change measures stopped working and gave error.

 

dax's avatar
dax
Community Support
6 years ago

Hi Anonymous , 

I don't know your error when you use legend index, I test this in my environment, I create relationship between them , and set sort by "ORDER", it works.

 

So I don't know  which cause this problem. If possible, could you please inform me your sample data or pbix(recommend to use OneDrive for Business, and you could use virtual data instead of real data)

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Can you try to see if this DAX works in your case:

    Chg Value Share = IFERROR((calculate(sum(Data[Sales]),Data[Time Period]="TY")/
    (calculate(sum(Data[Value Sales]),Data[Time Period]="YA"))-1,"")