Applying sort by for a new measure

Anonymous — Tue, 30 Jul 2019 15:32:08 GMT

Hi,

I have created a new measure for my matrix table to replace blanks with 0s.

My table has columns Direction, Date and Category. A new date table was created where date = Distinct([example[Date]).

New measure count category = SWITCH(

TRUE(),

ISBLANK(COUNT(example[Category])), 0,

COUNT(example[Category])

)

This measure replaces blanks with 0s. My problem is i am trying to do the same with other columns by creating tables and relationship but the "sort by column" i had previously applied to my columns are not copied onto the new measure i am creating thereby reordering the table.

Can someone explain/help me if/why and how to apply sortby option for a new measure.

Thank you!

Re: Applying sort by for a new measure

Stachu — Fri, 02 Aug 2019 04:12:01 GMT

does the sort work if you use

COUNT(example[Category]) + 0

to get rid of blanks? it should also be more performant, as it has no conditionals

topic Applying sort by for a new measure in DAX Commands and Tips

Applying sort by for a new measure

Re: Applying sort by for a new measure