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!

     

  • msatterwhite's avatar
    msatterwhite
    Frequent Visitor
    5 years ago

    Thank you for your response.  I've been trying to use the technique from your video and the links you provided but I'm unable to put my Buckets measure in the Rows area.  I think my direct-connection to SSAS prevents me from being able to use the Buckets measure the way I want to.  

    Have you tried your approach when using a "Connect-live" connection to SSAS?  I'm curious to know if it works.

    Thanks.

    Please see my reply to v-kelly-msft above, which goes into more detail.