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.

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.