topic Re: DAX Query in Report Server

DAX Query

GuestUser — Fri, 19 Jul 2019 12:10:59 GMT

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,

Re: DAX Query

d_gosbell — Mon, 22 Jul 2019 00:44:49 GMT

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.

Re: DAX Query

GuestUser — Mon, 22 Jul 2019 16:37:24 GMT

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

Re: DAX Query

d_gosbell — Mon, 22 Jul 2019 20:23:55 GMT

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.