Forum Discussion

msatterwhite's avatar
msatterwhite
Frequent Visitor
5 years ago
Solved

Using DAX Measure for Categories against SSAS Direct Connection

I have seen several posts about creating Categories using DAX but I'm having difficulty using any of them against my SSAS connection. I'm trying to create aging buckets and do a count of distinct ...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi msatterwhite ,

     

    Yes,you cant put measure in rows,could you use "No of days" instead?

    Such as below:

    If you need the column "No of days" showing in matrix ,you could hide it by tricks:Go to column headers>switch "word wrap":off

     

    You could check my updated .pbix file attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

     

v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi msatterwhite ,

 

Yes,you cant put measure in rows,could you use "No of days" instead?

Such as below:

If you need the column "No of days" showing in matrix ,you could hide it by tricks:Go to column headers>switch "word wrap":off

 

You could check my updated .pbix file attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

 

msatterwhite's avatar
msatterwhite
Frequent Visitor
5 years ago

Unfortunately, I'm still unable to use your solution.  In your solution, you have a column for NO of days that isn't calculated.  I have to calculate my NO of days as a measure built by subtracting my [End Date] column from today.  That's preventing me from being able to use NO of days as a row or column in a matrix.  

 

The only columns I get from my SSAS model are Category and End Date.  Are you able to find a way to get a matrix to display the same way if everything in it is a measure?

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi msatterwhite ,

     

    How do you like the solution as below:

    As only measure is available,if you dont have  a key column to summarize the [_Aging Buckets],then it would show similarly as above.

    The measure is as below:

    measure = 
var tab=SUMMARIZE('Table','Table'[Category],"aging",[_Aging Buckets])
Return
COUNTX(tab,[aging])

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

    • msatterwhite's avatar
      msatterwhite
      Frequent Visitor
      5 years ago

      Thanks Kelly.  That's the best I was able to do as well.  I was hoping to make it a summarized view of the data but it sounds like that's not possible with each of those fields being measures.  

       

      I appreciate your continued help.  I needed that confirmation.