Column Sorting Issues

[PhuongTN]

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]

In your measure try to use

ALLEXCEPT instead of ALL.

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

[PhuongTN]

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]

Hi @PhuongTN 

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,