Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am trying to create a new measure with another calculated measure I created.
Here is Demo data that I was given that works and I am trying to create a measure like the one that is highlighted, but see how in the demo data the Group % has the sum "E" icon ? So in the demo data, there is not issues when creating the measure ...
Now lets go to the real data ... my "Group %" aka "
Thanks in advance for the help!
Solved! Go to Solution.
Hi @jonnyA ,
If you just don't know how to sum a measure, please use SUMX function like this:
Sum_Group% = SUMX('Table', [Group%])
The Group% is a measure, the formula is:
Group% = SUM('Table'[Column1])
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@jonnyA , expected output is not clear
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
If you need % of over all avg try like
Group Average (Ignore Degree) =Divide( [Group Average], CALCULATE([Group Average], REMOVEFILTERS(Table_Charge_Dataset[Provider_Degree])))
This is sample data that I am trying to get work on my actual data ... The only difference might be is that I would want my table to show all "Provider %'s", even the ones that arent 10% above or Below the group average. See bottom screen shot)
Here are the measures being used in the sample data ...
Here is my data ...
If i were to use the measures for the demo data i have an issue creating "Measure = sum('Table'[Group%])" because Group% has the sum E in front of it, but in my real data the "Group%" is a measure I created, i.e has the calulcator icon.
Here is the formula i am using for the column titled "Group %" ...
Hi @jonnyA ,
If you just don't know how to sum a measure, please use SUMX function like this:
Sum_Group% = SUMX('Table', [Group%])
The Group% is a measure, the formula is:
Group% = SUM('Table'[Column1])
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |