Forum Discussion

JuhaU's avatar
JuhaU
Regular Visitor
4 years ago
Solved

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 a...
Need Help
  • JuhaU's avatar
    JuhaU
    4 years ago

    Hi

     

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

     

    Br Juha

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
JuhaU
Regular Visitor
4 years ago

Hi

 

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