Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |