Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello,
Sorry, that I posted similiar question here, but I think there is a misunderstanding what I was looking for.
I tried several ways to get the return of a aggregation in a summarized table which created column is defined as "name" of the summarize syntax.
So I get values for "name":
summarize(Tabelle2,[Status],"Name",DISTINCTCOUNT(Tabelle2[Status]))
So how to wrap this summarize function up into a sumx or countx to get the values I need?
If I use this: sumx(summarize(Tabelle2,[Status],"Name",DISTINCTCOUNT(Tabelle2[Status]))) it returns double the values, because DAX apparently has the total values in every row saved.
If I make a new calculated table and then sum up like sum(name) it works totally fine. But how to put it into a measure, without creating an extra table??
Thank you in advanced.
Best.
Solved! Go to Solution.
@Applicable88
var __table = summarize(Tabelle2,Tabelle2[Status],"Name",DISTINCTCOUNT(Tabelle2[Status]))
return
Sumx ( __table, [Name] )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Applicable88
var __table = summarize(Tabelle2,Tabelle2[Status],"Name",DISTINCTCOUNT(Tabelle2[Status]))
return
Sumx ( __table, [Name] )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @Fowmy,
that bears another question:
Since that approach build a table as a variable, why a regular sum doesn't work and why need a x-aggregated sumx here?
You need to use an iterative function to read and aggregate vale's off a virtual table.
Sorry, I am not clear about the expected result based on your explanation.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.