MIN of Quick Measures excluding zeros

[Anonymous]

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.

[Anonymous]

Hi @Anonymous 

Can you upload sampledata, pbix to GoogleDirve / One Drive and share the link here to find a solution.

Cheers

CheenuSing

[Anonymous]

Thank you CheenuSing I've managed to get aroundit with IF formulas. My only problem now is to view and make slicer selections on the report in the PowerBi app which is incredibly slow.....