The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have this matrix
I am having trouble getting the score totals to come out. I tried to do the Sumx(summarize(), calc) calcuation but from the context of Survey I can't reach standards. More details below.
My scored calculation is additive (so not non-additive), I thought but I am guessing it is not. It looks like this:
A better visualization with the questions are as follows. Again...incorrect totals though.
I am wondering if the relationship between Questions and QuestionStandards tables is causing the incorrect sums???
I tried to do the SUMX( Summarize(), calc) to see if that will work, but from the context of Survey, I can't add in the standards tables as they are accessible. This again makes me believe it's the Questions and QuestionStandards relationship that has things messed up.
Any Ideas?
Solved! Go to Solution.
Thank you for the response. The above didn't really solve the issue but I was able to get the result I needed. Here is my final measure, which uses the SumX(summarize(), calc) pattern.
Hi @mastone ,
Please create a measure.
result =
var _b = SUMMARIZE('Surveys','Surveys'[Chapter],"aaa",'Surveys'[Scored])
return
IF(HASONEVALUE('Surveys'[Chapter]),[Scored],SUMX(_b,[aaa]))
More details about measure total: Power BI: Totals Incorrect and how to Fix it - Finance BI (finance-bi.com)
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.
Thank you for the response. The above didn't really solve the issue but I was able to get the result I needed. Here is my final measure, which uses the SumX(summarize(), calc) pattern.