Hi All i'm failry new to Power BI and i think i'm complicating this one.
I have 18 x quick measures in 18 different tables named MAX1 to MAX18. Each of them can be zero or an integer number from 1 to 3 depending on my slicer selection of Yes or No.
I'm trying to set up a card with a formula that shows ZERO if the ALL of [MAX1] to [MAX18] equal zero. If one or more MAX measures are different to zero i'd like the MIN of [MAX1] to [MAX18] excluding the zeroes.
Each of the tables look like this:
| Description (1 to 18) | Category |
| Y | 1 to 3 |
| N | 0 |
Been going around in circles since there's no MINIF function in DAX trying to set up filters, and using IF/AND and other functions that will onyl take two arguments so i'm getting nowhere.
Your help would be much appreciated.
Thanks in advance.
