Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago
Solved

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 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.
BI-NOSUMA.jpg
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    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.

2 Replies

  • TheoC's avatar
    TheoC
    Icon for Community Champion rankCommunity Champion
    5 years ago
    Syndicate_Admin try the below measure please 🙂

     

     

    Ceros = 

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

    RETURN 

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

     

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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.