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
Hi All,
I want to show total equipment count 41 in power BI Like ( 1+1 +38+ 1= 41)
below table I have in spread sheet
Solved! Go to Solution.
Hi, @12CV
You can try the following methods.
Measure = CALCULATE(SUM('Table'[Equipment Number]),ALL('Table'))
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi, @12CV
You can try the following methods.
Measure = CALCULATE(SUM('Table'[Equipment Number]),ALL('Table'))
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi,
This is just example, number might be anything.
I want to achive the total count.
Hi, @12CV
Based on the example data you provided, can you explain why you expect the output to be 41?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!