Forum Discussion

Wresen's avatar
Wresen
Icon for Post Patron rankPost Patron
6 years ago
Solved

Sum values but dont show blanks

Hi  I have a little problem that i have tried to solve , not sure if its possible. I have two tables.   They have an relationship between Box - Box , single (right to the left table (bi...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Wresen here is the measure and what you need on filter

     

    Measure = CALCULATE( COUNTROWS ( 'Box Tran' ), ALLEXCEPT( 'Box Tran', 'Box Tran'[Month] ) )

     

     

    In table visual, drop Month and Box from (box table) and the measure above. and you will get this

     

  • MartynRamsden's avatar
    MartynRamsden
    6 years ago

    Hi Wresen 

     

    Try using ALLNOBLANKROW in place of ALL, as follows:

     

    Runningcount =
SUMX (
    FILTER (
        ALLNOBLANKROW ( 'Box Table'[Box] ),
        'Box Table'[Box]
            <= MAX ( 'Box Table'[Box] )
    ),
    [Amount]
)
  • MartynRamsden's avatar
    MartynRamsden
    6 years ago

    Sorry Wresen ,

     

    I forgot to mention that you'll also need to apply a filter on the 'Box' column in the visual:

     

MartynRamsden's avatar
MartynRamsden
Icon for Solution Sage rankSolution Sage
6 years ago

Hi Wresen 

 

If you delete the relationship between the two tables, you should get the result you're looking for.

However, doing this could break other parts of your data model or cause other measures to calculate incorrectly, so proceed with caution.

 

Best regards,

Martyn