cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Re: Passing between parameters to a measure using Whatif Analysis

Hi @Krishna_Mysore,

 

When you use a measure since it's based on context it returns an error. 

 

Try to change your measure to something like this:

 

Avg Selling Price Filtered Range =
VAR av_price = [Avg Selling Price (Billed) Monthly]
RETURN
    CALCULATE (
        [Avg Selling Price (Billed) Monthly],
        FILTER (
            Table,
            av_price >= MIN ( Parameter[Parameter] )
                && av_price <= MAX ( Parameter[Parameter] )
        )
    )

 

Change Table by the name of the table that as your data.

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Highlighted
Krishna_Mysore Regular Visitor
Regular Visitor

Re: Passing between parameters to a measure using Whatif Analysis

That worked.  Thanks a lot Felix