Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Raheem08
Frequent Visitor

Sum of Zero Billed Models Count

Hi All,

 

In below screenshot 'Zero Billed Model' Total is 2 but i want to get sum of Zero billed model that is 15

 

Thanks

 

 

Raheem08_0-1655654573358.png

 

5 REPLIES 5
Anonymous
Not applicable

Hi @Raheem08,

Any update on this? Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

AlB
Community Champion
Community Champion

Hi @Raheem08 

Create a new measure based on the one you already have:

ZeroBilledModel_Total =
SUMX ( DISTINCT ( Table1[Name] ), [ZeroBilledModel] )

 

SU18_powerbi_badge

Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

 

Raheem08
Frequent Visitor
AlB
Community Champion
Community Champion

@Raheem08 

What do you mean by please check?

Cannot access it. Share the pbix.  

SU18_powerbi_badge

Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

 

@ALLUREAN  

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.