Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi everyone,
I'm having this weird issue and desparately looking for a solution for this.
I have 3 measures which are Count, Average and Count * Average , the total of Average and Count * Average are not giving me the correct total as shown below :
As you can see the total for the Average and the Count * Average are not the expected total I need.
I tried SUMX(Table, (Count * Average)) technique but no avail.
Any calculation that will give me $3,434,682 for the Average and $6,363,700 for the for the Count * Average column would be great help!
Thanks!
Solved! Go to Solution.
you need creat 2 measures
1) m1 = Count * Average
2) m2 = SUMX( VALUES('Table'[ID]), [m1])
you need creat 2 measures
1) m1 = Count * Average
2) m2 = SUMX( VALUES('Table'[ID]), [m1])
Spot on! This seems to be working in my case. I tried using SUMX without the VALUES() function and just the table/column name which didn't work but this did.
Check out the November 2023 Power BI update to learn about new features.