How to mimic a sql IN query using powerbi on a SSAS cube

Question

Hi all.i am trying to mimic some kind of set filtering. In sql is is very easy, but i am using a SSAS cube.I would like to mimic this in powerbiIn the below query, i first determine which customers have an aggregated sales amount of over 1000. Then just for those customers, i need to list their name and countryselect CustomerID, CustomerName, CustomerCountryfrom CustomerTablewhere customerID in ( select customerID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; from SalesTable&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; group by CustomerID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; having sum(SalesAmount) &gt; 1000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)How to achieve this?

tahreem24 · Answer

MarcoDekker&nbsp; Create a new table using SUMMERIZE
New Table = SUMMERIZE(Table, Table[CustomerID],Table[CustomerName],Table[CustomerCountry],"Amount" SUM(SalesAmount)&gt;1000))
&nbsp;

marcodekker · Answer

Hi&nbsp;Tahreem24&nbsp;. Thanks for this suggestion.We use a SSAS cube provided by a supplier. I can use Dax allright when creating measures in a PBI report, but no columss or tables. So i am unable to use the summerize feature.regards, Marco&nbsp;

marcodekker · Answer

Anybody with an alternative aproach?

marcodekker · Answer

Nobody? Simply not possible?

Forum Discussion

How to mimic a sql IN query using powerbi on a SSAS cube

4 Replies

Related content

POWERBI Subscription

PowerBI Workspaces

PowerBI to Query AD Group Memberships

PowerBI Desktop Query Refresh Popup Not showing up

iframe powerbi