cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shwets47
Frequent Visitor

Totals in table displaying incorrect values

Hi Guys,

 

I have an issue in one of the main fact tables, I have a fact table which has Fee Submitted column for particular diagnosis and the sum of it is not giving me right totals in Power BI report. Below is the link of the relationship:

 

https://myhealthcentre365-my.sharepoint.com/personal/shweta_sagar_myhealthcentre_ca/_layouts/15/gues...

 

The model is very complex and no matter how i slice i end up getting some incorrect totals. i am not able to figure it out from where it is calculating! i just have a sum(Fee  Submitted) defined as Fee Claimed measure.

 

only if i put the measure i get correct totaols, the moment i slice it up on columns it gets to wrong one.

 

Regards,

Shweta

 

2 REPLIES 2
Ashish_Mathur
Super User III
Super User III

Hi,

 

Share the link from where your file can be downloaded.  Also, please show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
v-jiascu-msft
Microsoft
Microsoft

@shwets47,

 

Hi Shweta,

 

Did you mean you used the formula as a measure or a calculated column in the last sentence? If so, usually they would return different values due to they have different context. 

1. What is the formula? Maybe you specified some context in it. So the outcome would be strange when you try to filter it.

2. How did you slice it? Different slicers from different columns would return different results.

 

Please check out these two items. I can't do any more with limited information. Could you please share a sample in TEXT mode? The PBIX file would be great. At least the formula and the slicers you used.

 

Best Regards!

Dale

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.