Calculate percentage orders agreed

[janwillem]

I have made a formule for calculate % how many orders agreed, as follow:

Offertes akkoord = COUNT ( 'om_orders' [Ordernr.] ) /

                                               CALCULATE (

                                                                    COUNT ( 'om_orders' [Offertenr.] );

                                                                    'om_orders'[type] = 10

                                                                    )

When I select a specific "Productgroup" or "Item" percentage doesn't change.

How can I fix this?

[v-sihou-msft · Accepted solution]

@janwillem

Are "Productgroup" and "Item" column in same 'om_orders' table?

The issue should be related to the relationship between "Productgroup"/"Item" and 'om_orders' table. 

If "Productgroup" or "Item" can filter [type] column accordingly, it should work properly. See my sample below:

Regards,

[TomMartens]

Hey,

your percentages do not change, because of both parts of your division always consider the selected product item, for this reason one of your parts need something like this

CALCULATE(
  COUNT( ... )
  ,ALL('yourtable'[Product])
)

Hope this gets you started