Forum Discussion

Jc_16's avatar
Jc_16
Frequent Visitor
2 years ago
Solved

Filter

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?

Filter
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    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] )
)

     

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    2 years ago

    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] )
)