Control another measure with other

[JuhaU]

Hi

I have a following matrix in a report

Row Labels Sum of TotalStock Sum of ProductionAmount YTD

I would like Production Amount YTD to be excluded if Total stock is empty like in a6 row. This is easy that row, but how can I can exlude that in sum level (row a). So the final report should look like this

Row Labels Sum of TotalStock Sum of ProductionAmount YTD

TotalStock is a measure 

BR Juha

[JuhaU · Accepted solution]

Hi

As usual I found the solution immediatly after posting a question. Simple measure filter will do the trick.

Br Juha

[amitchandak]

@JuhaU , Try measures like

If(isblank(Total stock is empty) ,[Production Amount YTD], blank())

or

Sumx(summarize(Table, Table[Row Col1], Table[Row Col2], "_1",If(isblank(Total stock is empty) ,[Production Amount YTD], blank())  ), [_1]

[JuhaU]

Hi

This will work in detail level (a1-a7), but not in summarized level since totalstock isn't blank there.