Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
peoplehelpme
Helper I
Helper I

measure sum with filter but it give me wrong sum number

Dear sir

please help me 

i dont know why

this sum value gone wrong ,which i use filter'FY'from another table

peoplehelpme_0-1709086070343.png

buy when i use 'FY' from the same table , it result in right value ,

can anyone explain me pls and how to fix it if i want to use 'FY' from another table

i guess it might be the problem with data relationship but i dont know how to choose it properly

 

picture of 'FY' from another table:

peoplehelpme_1-1709086828474.png

picture of 'FY' that give me right sum value:

peoplehelpme_2-1709086887267.png

here is relationship between 2 table:

peoplehelpme_3-1709086972811.png

 

1 ACCEPTED SOLUTION
v-rongtiep-msft
Community Support
Community Support

Hi @peoplehelpme ,

Please have a try.

_result = 
var _b = SUMMARIZE('table','table'[date],"aaa",'table'[yourmeasure])
return
IF(HASONEVALUE('table'[date]),[yourmeasure],SUMX(_b,[aaa]))//you can change the [date] to the unique column (like index column ) in you table//

Or I have also found a similar post, please refer to.

Solved: Re: Incorrect total in Matrix - Microsoft Fabric Community

 

 

How to Get Your Question Answered Quickly - Microsoft Fabric Community

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

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

 

 

 

 

View solution in original post

2 REPLIES 2
v-rongtiep-msft
Community Support
Community Support

Hi @peoplehelpme ,

Please have a try.

_result = 
var _b = SUMMARIZE('table','table'[date],"aaa",'table'[yourmeasure])
return
IF(HASONEVALUE('table'[date]),[yourmeasure],SUMX(_b,[aaa]))//you can change the [date] to the unique column (like index column ) in you table//

Or I have also found a similar post, please refer to.

Solved: Re: Incorrect total in Matrix - Microsoft Fabric Community

 

 

How to Get Your Question Answered Quickly - Microsoft Fabric Community

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

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

 

 

 

 

peoplehelpme
Helper I
Helper I

the right answer should be 3.91 

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.