Using only measures (no Custom column) to make a fallback Column chart.

[asheyashey]

As mentioned I've been tasked make a Column chart while using only measures(been asked to avoid using Custom/ Cal Columns).
The chart includes-
X axis: ABC (date column) this needs to be measure.
Y axis: Count of SALES ID.

The logic for the calculation for ABC is- if A<> null then A elseif B<>null then B elseif C<> null then C else NULL. 
There are 3 coloumns( A,B,C all date columns).

The X axis To include a month-to-day drill-down capability.


I'm familiar with how to do this using calculated columns but having great difficulty navagating measures.
Would greatly appreciate some help.And Dax codes would be greatly appreciated.

[FBergamaschi · Accepted solution]

Measures cannot be grouped in X axis.

In X axis (or in rows / columns of a matrix) you can only group columns.

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[FBergamaschi · Accepted solution]

Measures cannot be grouped in X axis.

In X axis (or in rows / columns of a matrix) you can only group columns.

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[asheyashey]

Is there anything else how possible to approach such a problem ? or it's a deadend

[KNP · Accepted solution]

No, @FBergamaschi's answer covers it. 

Measures can't be used in that way. A calculated column (as far upstream as possible) is the correct way.