Column Sorting Issues

Anonymous · ‎07-20-2019

Hello,

I am trying to sort my Month-S column by Month-N and it's not giving me any error message.

However, the other calculated columns referencing the Month-S column all turn into errors. I tried sorting Month-S by other columns as well and it still turn those columns into errors.

I'm can't seem to find a solution. Please help!

Thanks,

PN

sokg · ‎07-20-2019

In your measure try to use

ALLEXCEPT instead of ALL.

Can you share the [SHOW MM?] calculation???

Anonymous · ‎07-20-2019

Hi @sokg,

Here is the [SHOW MM?] measure:

SHOW MM? = if(day(max('SD-ACTUALS'[Date]))=15, if([StartOFLatestMYSMonth]<[StartOFCurrentMonth],"YES","NO"),"NO")

v-cherch-msft · ‎07-21-2019

Hi @Anonymous

I would suggest you create a calculated column [SHOW MM?] in the table.Then create calculated column [Month-S-P] by calculating [SHOW MM?].Please do not calculate measure in columns.

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.