MDX query for filtered slicer in Power BI

[BossCo]

Hi! I've got a PowerBi report connected to a SSAS Multidimensional model (cube). I'm writing all my queries in MDX.

I need a customer slicer which only shows me customers with sales. Is there a way to do this?

Thanks

[BossCo]

Hi, being connected to a SSAS cube, is not possible neither to create a new measure in DAX nor to filter the slicer by a measure. I'm trying to solve the problem in Analysis Services. Thanks!

[v-deddai1-msft]

Hi @BossCo ,

You can  create  a measure , and add it to visual level filter :

measure = SUM(Table[sales])

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[amitchandak]

@BossCo , If you have slicer from the customer which has all customers.

filter it on sales <> blank.

This for two slicers, but will work for one slicer too

https://www.youtube.com/watch?v=cyOquvfhzNM