Filtering in a formule with slicers

[janwillem]

I have made a formule for Offer Agreement as follow: 

COUNT ('om_orders'[Ordernr.]) /

CALCULATE (

                      COUNT ('om_orders'[Offertenr.]);

                      'om_orders'[type] = 10

                     ) 

I have also slicers for Productgroup and Item and I will use them for this calculation.

At the moment when I choose a Productgroup nothing change.

How can I fix this.

[Eric_Zhang]

---

@janwillem wrote:

I have made a formule for Offer Agreement as follow: 

COUNT ('om_orders'[Ordernr.]) /

CALCULATE (

                      COUNT ('om_orders'[Offertenr.]);

                      'om_orders'[type] = 10

                     ) 

I have also slicers for Productgroup and Item and I will use them for this calculation.

At the moment when I choose a Productgroup nothing change.

How can I fix this.

---

@janwillem

Is the formula a calculated column or measure? For calculated column, it won't be affected by any slicer. 

[Anonymous]

@janwillem

Can you share a screenshot of your results? It's probably specific to your data. Maybe you didn't relate the tables? There could be a number of possible issues here.

Best,

Martin