Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 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.
Is the formula a calculated column or measure? For calculated column, it won't be affected by any slicer.
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
User | Count |
---|---|
85 | |
76 | |
73 | |
70 | |
56 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |