Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.