Forum Discussion
Anonymous
4 years agoNot applicable
dax filter non zero
Hi, I'm new in Power BI, and I try to see any method if I want to see the list of value are there never reaching zero in weekly.
The table will shown below:
| Timestamp | Type | Value |
5/5/22 | Basement | 60 |
| 5/5/22 | Basement | 50 |
| 7/5/22 | Basement | 0 |
| 8/5/22 | Washer | 60 |
| 4/5/22 | Washer | 70 |
So the result will tell me at that week, washer never reach zero in dashboard.
Thanks for your help.
Anonymous
Here is a link to download a sample solution file:
dax filter non zero 2022-08-08.pbix
5 Replies
- SpartaBICommunity Champion
Anonymous
Here is a link to download a sample solution file:
dax filter non zero 2022-08-08.pbix