Forum Discussion
Control another measure with other
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
Hi
As usual I found the solution immediatly after posting a question. Simple measure filter will do the trick.
Br Juha
3 Replies
Hi
As usual I found the solution immediatly after posting a question. Simple measure filter will do the trick.
Br Juha
- amitchandak
Super User
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]
Hi
This will work in detail level (a1-a7), but not in summarized level since totalstock isn't blank there.
