Measure Issue

CharanY28 — Tue, 25 Mar 2025 13:53:12 GMT

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

Re: Measure Issue

Chanty4u — Tue, 25 Mar 2025 17:09:37 GMT

Try this

NUM(

Count({

[Fact Type] = {'Ld'},

[Institution Name] = {"=Sum([total spend]) > $(vSpentThreshold)"}

} DISTINCT [Ld ID]), '#,##0'

)

topic Re: Measure Issue in App Development

Measure Issue

Re: Measure Issue