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

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper 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] )
)