Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I'm pulling the data for two columns and for column1 from one table it is sum and column 2 is from another table it is the count. For these two tables I have another table and I'm giving relation ship between these two tables. But It is many to many relation ship .
Here is the sample data
column1 column 2 id
argentina --
brazil
spain
italy
swizerland
6716 509
Here is the problem when I'm giving the filter for above visual for column 2 I'm getting right count but I'm getting wrong count for id i.e 504 I don't know what i'm missing
hi, @Anonymous
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Best Regards,
Lin
The problem has not solved
hi, @Anonymous
Sample pbix file or Sample data and expected output would help tremendously. Just from your description, we couldn't find out the reason.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
and also if it is a measure totals problem. See this post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Best Regards,
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |