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...
Need Help
LaurentCouartou's avatar
LaurentCouartou
Solution Supplier
9 years ago

I assume you are using a DirectQuery mode and that is why you cannot use the CALCULATE function in a calculated column.

 

Anyway, the default measure does not return the expected results because of the propagation of filter: TCOM_PEDSAI filters TCOM_ITEDPS, which filters TCOM_PROSER.

 

You will have to write the relevant measure. The measure should look something like this: 

= CALCULATE( YourExpression
    , SUMMARIZE( TCOM_PROSER 
             , TCOM_PEDSAI[PEDS_COD]
    )
)
  • vitinho's avatar
    vitinho
    Helper I
    9 years ago

    Hi, thanks for the help. But Summarize function don't appear for me either. any ohter idea what this could be?

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      This has been brought up in at least two threads now. Are you using import, or direct query? Some functions are limited in direct query mode.

      • vitinho's avatar
        vitinho
        Helper I
        9 years ago

        Direct Query

    • LaurentCouartou's avatar
      LaurentCouartou
      Solution Supplier
      9 years ago

      I forgot to mention I activated the following options:

      File > Options and Settings > Options > DirectQuery > Allo unrestricted measures in DirectQuery mode

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        LaurentCouartouI believe that only makes those restricted functions available for measures, and vitinho is trying to use them in columns. I don't think that option will help here.