Sum of Rows vs Expression Total logic in Power BI

[VineetaSirohi]

Hi , 

I need help in converting one logic implemented in Qlikview to have same in Power BI. The specific measure is using Sum Of Rows in place of "Expression Total" in Qlikview. Ideally it should be expression total for measures which is working fine  in Power BI when I put measure formula in Power BI.

Now, when I am putting the expression for measure in Power BI , the measure total in PBI visual is not matching. Total in not matching when data is exported to csv. Say, Measure Total = 100 in Power BI visual. On export to excel/csv , total comes 40 (this total is same as in QLikview due to sum of rows option) 

Attaching PBIX for referance.

The measure Total Invoice Value$ is the one what is causing issue. WHen export the visual the some for this measure column is not matching to PBI sum.

Pls help here urgently.

Thanks.

[VineetaSirohi]

Just relaised I am not able to attach PBIX file here for referance. Can anyone suggest how I can attach one here.

[v-yiruan-msft]

Hi @VineetaSirohi ,

You can upload your pbix file to OneDrive for Business, then share the file link with me. Please find the details in the following documentation.

Share OneDrive files and folders

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

[VineetaSirohi]

@v-yiruan-msft 

The access on OneDrive is very limited and I can't share the URL with access out of organization, Is there any other way to check this. I have PBIX file but not able to share.  even specific people is also not working. Any other way !

[v-yiruan-msft]

Hi @VineetaSirohi ，

You can paste your sample data with Text format(as below table) in your post and explain your desired result with calculation logic. Thank you.

Field 1	Field 2	Field 3
ID1	AA	2
ID2	BB	6
ID3	CC	8
ID4	DD	4

Best Regards