Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
How come this expression not work?
I wanna show those companies who have data in this year in my listbox
=if(sum({<Year={$(vYearToday)},"[DimCustomer].CustomerName">} "[FactQVTimeRegistered].TimeRegistered") > 0, "[DimCustomer].CustomerName", null())
Try
=aggr(
if(sum({<Year={$(vYearToday)},"[DimCustomer].CustomerName">} "[FactQVTimeRegistered].TimeRegistered") > 0, only({<"[DimCustomer].CustomerName">} "[DimCustomer].CustomerName") )
,
"[DimCustomer].CustomerName")
)
Try
=aggr(
if(sum({<Year={$(vYearToday)},"[DimCustomer].CustomerName">} "[FactQVTimeRegistered].TimeRegistered") > 0, "[DimCustomer].CustomerName")
,
"[DimCustomer].CustomerName")
)
edit: removed misplaced equal sign
I also had something similar to this before - The only downside about this aggr. is that when selection a company then i will only see this company (I see companies who are faded out with grey)
Is it possible to do so, i get all companies with data, but when selecting a company the others are greyed out.
Nope- My variable is a int, so it works fine (tested it with other expressions)
Try
=aggr(
if(sum({<Year={$(vYearToday)},"[DimCustomer].CustomerName">} "[FactQVTimeRegistered].TimeRegistered") > 0, only({<"[DimCustomer].CustomerName">} "[DimCustomer].CustomerName") )
,
"[DimCustomer].CustomerName")
)
Oh your good!
Thank you Can you explain why? and what the difference is?