Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
Hello all
I would like to have in a slicer the number of contracts made.
Now, i want to know, for example, which clients has 3 contracts or whatever number i choose.
My fact table, contracts, is connected to clients, many to one.
Can you help me on step by step proccess, because last time i thought the solution was good but it turns out not to be good.
This is what i would like to see
Thank you all in advance
Solved! Go to Solution.
Hey @pedroccamaraDBI , it is not a measure but a calculated column that you create on your DIMENSION table (the one with each id/name occuring only 1 time),
And for your example it would give something like :
Hey @pedroccamaraDBI ,
First create a calculated column on you dimension table containing all clients name (the one part of your relationship)
Then add this column to a slicer if you want to be able to select the number of contract :
Best regards,
Hello @philouduv
Could you please check your measure because i can't do it here. Doesn't allow me to write the filter expression
Hey @pedroccamaraDBI , it is not a measure but a calculated column that you create on your DIMENSION table (the one with each id/name occuring only 1 time),
And for your example it would give something like :
@pedroccamaraDBI , seem like you need Avg no of contract per client
AverageX(summarize(Contract, Clinet[Client], "_1", Count(Contract[Contract no]) ), [_1])
Hello @amitchandak
I really need the total for each client so i can filter it later on, and may know, for example, which clients has exactly 3 contracts
Check out the May 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
17 | |
15 | |
14 | |
12 | |
11 |
User | Count |
---|---|
10 | |
9 | |
8 | |
8 | |
7 |