Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have a line chart that shows 4 measures, like those below, and a Month dimension. I want to limit those to show when the sum of measure 1 is > 0 for each month.
Current Expressions:
SUM({<[Field]={'Source1'}>} [Measure1] )
SUM({<[Field]={'Source1'}>} [Measure2] )
SUM({<[Field]={'Source1'}>} [Measure3] )
SUM({<[Field]={'Source1'}>} [Measure4] )
This is what I want:
SUM({<[Field]={'Source1'}, SUM({<[Field]={'Source1'}>} [Measure1] ) > 0 >} [Measure1] )
SUM({<[Field]={'Source1'}, SUM({<[Field]={'Source1'}>} [Measure1] ) > 0 >} [Measure2] )
SUM({<[Field]={'Source1'}, SUM({<[Field]={'Source1'}>} [Measure1] ) > 0 >} [Measure3] )
SUM({<[Field]={'Source1'}, SUM({<[Field]={'Source1'}>} [Measure1] ) > 0 >} [Measure4] )
Can someone help me with the syntax or know of another way to do this?
Thanks1
May be this
Sum({<[Field] = {'Source1'}, Month = {"=Sum({<[Field] = {'Source1'}>} [Measure1]) > 0"}>} [Measure1])
Sum({<[Field] = {'Source1'}, Month = {"=Sum({<[Field] = {'Source1'}>} [Measure2]) > 0"}>} [Measure2])
Sum({<[Field] = {'Source1'}, Month = {"=Sum({<[Field] = {'Source1'}>} [Measure3]) > 0"}>} [Measure3])
Sum({<[Field] = {'Source1'}, Month = {"=Sum({<[Field] = {'Source1'}>} [Measure4]) > 0"}>} [Measure4])
May be this
Sum({<[Field] = {'Source1'}, Month = {"=Sum({<[Field] = {'Source1'}>} [Measure1]) > 0"}>} [Measure1])
Sum({<[Field] = {'Source1'}, Month = {"=Sum({<[Field] = {'Source1'}>} [Measure2]) > 0"}>} [Measure2])
Sum({<[Field] = {'Source1'}, Month = {"=Sum({<[Field] = {'Source1'}>} [Measure3]) > 0"}>} [Measure3])
Sum({<[Field] = {'Source1'}, Month = {"=Sum({<[Field] = {'Source1'}>} [Measure4]) > 0"}>} [Measure4])
It works! Thank you!