DAX Query

[GuestUser]

Hi,

We have Power BI Report Server (May 2019) edition

Power BI is connected with datasource SSAS (COnnect Live Option) - we understand that edit queries (Power query) gets disabled -- So group by option cant be used

Can u please help me out to write DAX measures to achieve the following (The tables are already joined in SSAS)

select
B.type,
C.category,
sum(sales_amount)

from
fact A,
storedim B,
categorydim C

where A.store_wid = B.row_wid
and A.category_wid = C.row_wid

group by

B.type,
C.category,

[d_gosbell]

You should not need to do anything in Power Query for this. If the tables are already joined just dragging the type, category and sales amount onto a table visual should give you the same output as that SQL query.

[GuestUser]

Thanks for replying!!

But it is not working as expected!!

We have created Sum(Sales_Amount) measure

and dragged columns store_type , category and sum(sales_amount) on table visual

But the sales amount is showing incorrect - It is showing same values for all

it is not doing group by 

Any suggestions pls

[d_gosbell · Accepted solution]

---

@GuestUser wrote:

But the sales amount is showing incorrect - It is showing same values for all

it is not doing group by 

---

That typically indicates that there is not an active one to many relationship between the store and sales and category and sales.