MEASURE DOES NOT ADD UP IN SUBTOTALS

[Syndicate_Admin]

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.

[TheoC]

Hi @Syndicate_Admin,

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 🙂

[v-rzhou-msft · Accepted solution]

Hi @Syndicate_Admin 

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.

[TheoC]

Hi @Syndicate_Admin,

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 🙂