Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,
Solved! Go to 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.
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.
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
@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.