Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have one scenario, I have Requirement like when sum(total spend) is > 0, show Lds, ens etc.
I have created slider for it , created vSpentThreshold variable which has value 0 and Given 0 to 50,000 as min and max with 10,000 as step, when sum(total spend) is > 0, it should remove those institute names in pivot chart which have spend = 0 it removes Lds and other measures also
For this I created Lds measure as below:
NUM( Count({< [Fact Type]={'Ld'}, [Institution Name]={"=If($(vSpentThreshold) = 0, 1, Sum([total spend]) > $(vSpentThreshold))"} >} DISTINCT [Ld ID]), '#,##0' ) When I'm doing this it's removing "-" institutes even when slider at 0
I have used below measure also not working
NUM( Count({< [Fact Type]={'Ld'}, [Institution Name]={"=If($(vSpentThreshold) = 0, 1, Sum([total spend]) > $(vSpentThreshold)) OR IsNull([Institution Name]) OR [Institution Name] = '-'"} >} DISTINCT [Ld ID]), '#,##0' )
WHEN i give Count({< [Fact Type]={'Ld'}>} DISTINCT [Ld ID]), It'a giving "-" included count also
I enabled Show null values also for Institution name in Dimension
Could anyone please help me on this
Try this
NUM(
Count({
<
[Fact Type] = {'Ld'},
[Institution Name] = {"=Sum([total spend]) > $(vSpentThreshold)"}
>
} DISTINCT [Ld ID]), '#,##0'
)