summarize report with 2 tables , not working

Question

Hi&nbsp;&nbsp;I create 2 tables, one covers operating info, the other with financial info, both are linking with order numbers, I tried to group them by gain or loss. the report is as below&nbsp;GAIN/LOSS | &nbsp;JOBS | &nbsp;CW_KG | Profit&nbsp;gain &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100 &nbsp; &nbsp; &nbsp;500 &nbsp; &nbsp; &nbsp;500loss &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100 &nbsp; &nbsp; &nbsp;500 &nbsp; &nbsp; &nbsp;-350total &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100 &nbsp; &nbsp; &nbsp;500 &nbsp; &nbsp; &nbsp; &nbsp;-150The reality is gain job 75, loss job 25, financial profit is correct. How can I fix this? thanks&nbsp;&nbsp;

anonymous · Answer

you have just provided the expected result without the source data, please share full required details.

reedzhou · Answer

I cannot attached file, please go to below link to view, thanks

https://app.powerbi.com/view?r=eyJrIjoiOWNjNzk3NjctMTJkOS00MmMxLWI1MTktMTM0OWU4MTRlNGIzIiwidCI6ImRiYWM5OTYyLWE3YWYtNDExOS1hY2QyLTQzMDZjOGU5Y2EwOCIsImMiOjh9

v-frfei-msft · Answer

Hi&nbsp;REEDZHOU,
&nbsp;
Could you please share your sample data and excepted result to me? You can upload your file to dorpbox and share the link here.
&nbsp;
Regards,
Frank

reedzhou · Answer

Hi please see below I store file in there, thankshttps://www.dropbox.com/s/38enikq3wwdhurk/TEST.pbix?dl=0

v-frfei-msft · Answer

Hi&nbsp;REEDZHOU,
&nbsp;
Please update your measure job to this one.
&nbsp;
jobs = COUNT('MS ODW CONNECT'[UTN])

For more details, please check the pbix as attached.
&nbsp;
Regards,
Frank

Forum Discussion

summarize report with 2 tables , not working

10 Replies

Related content

Parameter in summarize

Don't Summarize....still summarizes...?

Usage Metrics Report - Not Working For Certain Reports

GroupBY and summarize

Default Summarization Not Working