Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Removes row with all 0

Hi Power Bi Community,   How do i remove the row with all 0. I have a matrix table which looks something like this: The data that I put for my matrix table is:   I've created a measure for...
Need Help
MahyarTF's avatar
MahyarTF
Icon for Memorable Member rankMemorable Member
3 years ago

Hi,

Maybe if you change your measure as below, it helps you :

Measure Hours = 

Var calc = CALCULATE (
(100 - SUM ( 'Staff Booking'[Loading])) * 0.08,
FILTER (
'Staff Booking',
'Staff Booking'[Relevant Job Start Date] <= ThisDate &&
'Staff Booking'[End date] >= ThisDate 

)

Return if ( Calc <> Blank(), Calc)

Anonymous's avatar
Anonymous
Not applicable
3 years ago

The result would still be like this:

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

    Which field is the column of the matrix? Then create a measure that ignores the filter for that field, such as:

    Measure = CALCULATE([Measure Hours],ALL('Table'[Date]))

    And apply it to the matrix's filter:

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data