cancel
Showing results for 
Search instead for 
Did you mean: 

SAC Measure input control doesn't work

ypinchuk
Explorer
0 Kudos

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
N1kh1l
Active Contributor
0 Kudos

@ypinchuk 

If you go with measure based filter you might not able to plan in the table. Instead of measure based filter, try creating a measure based dimension using the measure values to create dimension category. Make sure you cover all possible values for the measure including null. Then you can use this dimension to filter the table.

Nikhil

ypinchuk
Explorer
0 Kudos
Nikhil, it's analytic table, not planning. I created a measure based dimension but it doesn't work with unbooked date members