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 products 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.

[V-lianl-msft · Accepted solution]

Hi @Syndicate_Admin ,

Do you want to calculate the number of products with KPI = 0 in each group?

Please try measure like below:

Measure 2 = 
IF ( ISINSCOPE ('Table'[sub_] ), [Measure],CALCULATE(COUNTX(VALUES('Table'[sub_]),[Measure]),ALLEXCEPT('Table','Table'[Type])) )

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

[TheoC]

@Syndicate_Admin try the below measure please 🙂

Ceros = 

VAR _KPI = SUM ( 'Table'[KPI] )

RETURN 

IF ( _KPI = BLANK() , 0, _KPI )