Filtering in a formule with slicers

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

---

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.