cancel
Showing results for 
Search instead for 
Did you mean: 

RESTRICT Function in New Model

PM8
Participant
0 Kudos

Can Restrict function be used with measures in the model? I am not getting any value.

Accepted Solutions (1)

Accepted Solutions (1)

N1kh1l
Active Contributor

manot

Use LOOKUP instead of RESTRICT and it should work for you. Below I have created 2 measures one using LOOKUP and other using RESTRICT with simple version pointing to Actuals. RESTRICT Measure will show values in first table only when the version is set to Actuals instead of Budget.

LOOKUP([VALUE],[d/Version]="public.Actual")

RESTRICT([VALUE],[d/Version]="public.Actual")

Output:

Hope this helps !!

Nikhil

PM8
Participant
0 Kudos

Thank you, nikhil_1486

Answers (0)