Forum Discussion
NJ81858
3 years agoHelper IV
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...
- 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] )
Jihwan_Kim
3 years agoSuper User
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] )