Forum Discussion

NJ81858's avatar
NJ81858
Helper IV
3 years ago
Solved

Sum Measure

Hello,   I have a measure that is supposed to be taking a sum of the fees associated for each product on each given day, but instead it is taking a plain sum of everything. My table looks something...
  • Jihwan_Kim's avatar
    3 years ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

    It is for creating a measure.

     

     

     

    Expected result measure: =
    SUMX ( SUMMARIZE ( Data, Data[Product], Data[Date], Data[Fee] ), Data[Fee] )