Forum Discussion
Post Partisanuserelationship
Hello tamerj1
This report has none filters or rows or columns anything related to dates.
About my request, do you have any suggestion on how to do this measure?
Thanks
Super UserCan you show what you mean by "doesn't work"? What are you currently getting and what do you expect to get?
Post PartisanHello AlexisOlson
Thank you for replying. I'm not an expert on DAX, far from it, but i came up with this solution by trying and trying:
1st question : can you explain this measure?
Now i need to create a measure with distinctcount all contractsID and this is the measure that it's not working. It shows me 3 instead of 2. Maybe if i understood what this measure means....
Can you help?
Thanks a lot
- AlexisOlson
I don't think I have enough information to give a good answer. It's difficult for me to understand what you're trying to do without seeing any underlying data and what result you're expecting based on that data.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
- pedroccamaraDBI
Hello AlexisOlson
I am very sorry to say but my data is kinda sensitive.
Let me give you a better explanation of what i need:
Remember my model up there, where i show in my model that my contract seller table as a many to one relation with contracts.
Then, i want a distinctcount of all contracts, by a specific seller name and a typeseller, which is in the matrix and in a filter box, respectively. In this matrix visual there's other fields from contracts, like cost center and Age contract for example. There's not any date filter although this contracts table is connected with dates table with an inactive connection.
This is my table
In my report, matrix, for Person1 AS A SELLER (selected already in the filter box) there are only 3 contracts, each one with its age contract, 2 contracts >3 month and 1 contract >6 month. Another example to have a proper distinctcount, Person2 has only 1 contract as a seller,as well as Person 3. But if my filter change from Seller to Manager, i will have 2 contracts for Person1, 1 for Person2, another for Person3 and none for Person4.
I hope you can help me with this explanation.
Thank you very much