cancel
Showing results for 
Search instead for 
Did you mean: 

SAC Measure input control doesn't work

ypinchuk
Explorer
0 Kudos
273

Hi SAC Experts,

In a SAC story, I tried to create input control based on the calculated measure. ypinchuk_0-1713801188640.png

This measure appeared in the list of available measures 

ypinchuk_1-1713801214690.png

but didn't filter the table (I wanted only lines with 1 to be present).

ypinchuk_2-1713801416491.png

The measure calculation refers to the Date dimension. The Date dimension is set up to show unbooked values, nevertheless, the filter didn't work either with booked dates or unbooked ones. 

In addition, another measure above - Age - is also a calculated measure, but it didn't even appear in the list of available ones for the filter.

Please, could you advise what could be the reason for this and how to make things work?

 

Thank you,

Yuri

 

View Entire Topic
Vivek-Varma
Advisor
Advisor
0 Kudos

Hello @ypinchuk ,

One solution that can be considered is to create an Account/Measure-Based Dimension, select the account/measure based on which you want this dimension to be made and check "Use Account Values as dimension members". (please refer to below image)

VivekVarma_0-1713899011900.png

 

This will directly use the measure values and you won't have to specify range conditions.

Please let me know if this solution works for you.

ypinchuk
Explorer
0 Kudos
Hi Vivek, unfortunately it doesn't help. I created the measure-based dimension as you suggest but it didn't impact the table neither as input control, nor as filter set in table builder.