Filter

[Jc_16]

Hello everyone,

I'm trying to build a measure and I want to:

1 get the selected value on a filter ( name of house)

2 use the selected value ti search the category of the house

3 calculate the revenue of the caregory.

so I need to ignore the house selected but at the same time I want it preaviously.

could you please helo me?

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Revenue: = 
SUM( revenue_fact[revenue] )

Revenue Category =
CALCULATE (
    [Revenue:],
    REMOVEFILTERS ( house_dim[house] ),
    VALUES ( house_dim[category] )
)