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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Administrator

## MEASURE DOES NOT ADD UP IN SUBTOTALS

Hello

I have a sales and inventory dashboard, with a branch-item level and I get an incognita with a measure that does not add up in the subtotals per branch, it only considers me the articles.

the idea that I want to capture is that the articles with inventory in zero I add them by branch, to know how many articles I have to fill, my formula is:

Ceros = IF([KPI]=0,1,BLANK())

annex image for best illustration.

hopefully you can help me, thank you very much.

1 ACCEPTED SOLUTION
Community Support

I think [KPI] and [Ceros] are both measures. Your problem should be that there is no total in [Ceros] measure in your matrix visual as below.

I suggest you to create a new measure based on [Ceros] measure.

``````New Ceros based on Ceros =
SUMX('Table',[Ceros])``````

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 REPLIES 3
Super User

I applied your steps and created a Calculated Column with your "CEROS" and got the following:

I think you may have used a measure instead of a Calculated Column possibly?

Let me know either way! Hope the above helps.  If the above doesn't solve your problem, I recommend checking the field settings on your visual and ensure you have the Row Subtotals on for your relevant columns 🙂

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Community Support

I think [KPI] and [Ceros] are both measures. Your problem should be that there is no total in [Ceros] measure in your matrix visual as below.

I suggest you to create a new measure based on [Ceros] measure.

``````New Ceros based on Ceros =
SUMX('Table',[Ceros])``````

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User

I applied your steps and created a Calculated Column with your "CEROS" and got the following:

I think you may have used a measure instead of a Calculated Column possibly?

Let me know either way! Hope the above helps.  If the above doesn't solve your problem, I recommend checking the field settings on your visual and ensure you have the Row Subtotals on for your relevant columns 🙂

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

## Helpful resources

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors