Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the below expression but How can I put that in set analysis ?
IF(_BTUnitOfMeasure = 'SQF',Sum(Total([RSF])),
Sum(Total([RSF])) * VarSfTOM2)
Thanks much.
May be like this:
RangeSum(
Sum(Total {<_BTUnitOfMeasure *= {'SQF'}>}[RSF]),
Sum(Total {<_BTUnitOfMeasure -= {'SQF'}>}[RSF]) * VarSfTOM2)
May be like this:
RangeSum(
Sum(Total {<_BTUnitOfMeasure *= {'SQF'}>}[RSF]),
Sum(Total {<_BTUnitOfMeasure -= {'SQF'}>}[RSF]) * VarSfTOM2)
You can make it something like this:
=Sum(Total {<_BTUnitOfMeasure = {'SQF'}>} ([RSF])) + Sum(Total {<_BTUnitOfMeasure -= {'SQF'}>} ([RSF])) * VarSfTOM2
Let me know if you got it right
Best regards,
D.A. MB
Thank you.