Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |