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 have an issue regarding creating correct dax formula.
I have two tables.
I want to get the total right, to show how many people who have at least 75 reviews.
Below is the formulas I've tried, but non of them works to get the total right.
Formula 1 tried:
Formula 2 tried:
Formula 3 tried:
Formula 4 tried:
Solved! Go to Solution.
HI @Anonymous ,
Please check on below link:
Measure Totals, The Final Word
If above not help, you can upload sample file to onedrive or google drive then share link here.
Notice: do mask on sensitive data.
Regards,
Xiaoxin Sheng
Hi @Anonymous ,
It seems like a common total level calculate issue on measure formulas, please refer to following blog about measure calculated on total level:
Measure Totals, The Final Word
If above not help, please share a pbix file with some sample data for further test.
Regards,
Xiaoxin Sheng
Hi,
This is what I see when I click the link.
Thanks
HI @Anonymous ,
Please check on below link:
Measure Totals, The Final Word
If above not help, you can upload sample file to onedrive or google drive then share link here.
Notice: do mask on sensitive data.
Regards,
Xiaoxin Sheng
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 |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |