Forum Discussion

GuestUser's avatar
GuestUser
Helper V
7 years ago
Solved

DAX Query

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,

DAX Query
Help me please
  • d_gosbell's avatar
    d_gosbell
    7 years ago
    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.

3 Replies

  • d_gosbell's avatar
    d_gosbell
    Super User
    7 years ago

    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's avatar
      GuestUser
      Helper V
      7 years ago

      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's avatar
        d_gosbell
        Super User
        7 years ago
        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.