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 grou...
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.

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.