Forum Discussion

vitinho's avatar
vitinho
Helper I
9 years ago

Related Table grouping sum

I'm using some related tables to create a report, the left most table has the values sold, and the right most table has the information which I want to group by. Power bi isn't able to create the sum or the count by itself and don't give me the option to use the calculate function, Any one knows what is happening?
The DAX CALCULATE function is not avaiable when I'm trying to create a calculated column, only avaiable when creating a measure, is it related with my problem?

Need Help

1 Reply

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago

    vitinho

    To have a better understanding on the situation, could you please upload you pbix? You can mask the sensitive data before uploading.