Forum Discussion
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 my value which looks something like
Measure Hours =
)
Rows = Name
Columns = Date
Values = Measure Hours
The table that I want to have looks something like this:
In summary, I want to remove the name who has all 0 for the date.
Thank you, appreciate any help I can get!
7 Replies
vicky_Super User
I think the easiest way would be to drag your Measure to "Filters on This Visual", and then select Measure Hours is not 0.
- MahyarTF
Memorable Member
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)
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 TeamIf 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
did you ever had a solution ?
I have the same issue