Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Dear sir
please help me
i dont know why
this sum value gone wrong ,which i use filter'FY'from another table
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:
picture of 'FY' that give me right sum value:
here is relationship between 2 table:
Solved! Go to Solution.
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.
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.
the right answer should be 3.91
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |