Forum Discussion
Solved
Sum up minimum value and 0 value
Hello, I'm working on this power BI Matrix and not sure about this step forward. I have brought minimum values of each region's rate based on their dates. I used the formula of SWITCH ( TRUE (), ...
Hi sunah132
You could try this measure:
Measure_Value = IF ( ISINSCOPE ( 'Table'[Route] ) && ISINSCOPE ( 'Table'[Date] ), MIN ( 'Table'[Value] ), SUM ( 'Table'[Value] ) )Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Thank you for the suggestion!
I tried on your suggestion and I should have mentioned this but there are multiple routes under each region. When I applied on yours, it took the sum including 0 but wasn't able to show the route rate at drill down.
| Region | 1-Jun | 2-Jun | 3-Jun | 4-Jun | 5-Jun | Total |
| Austin | 10 | 10 | 10 | 10 | 40 | |
| 1 | 2 | 2 | 2 | 2 | 8 | |
| 2 | 3 | 3 | 3 | 3 | 12 | |
| 3 | 3 | 3 | 3 | 3 | 12 | |
| 4 | 2 | 2 | 2 | 2 | 8 |
Hi sunah132
You could try this measure:
Measure_Value =
IF (
ISINSCOPE ( 'Table'[Route] ) && ISINSCOPE ( 'Table'[Date] ),
MIN ( 'Table'[Value] ),
SUM ( 'Table'[Value] )
)
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.