I am actively looking for the solution to resolve the issue appeared several times in my Power BI report. So I have created the measure to calculate the distinct count of the users which are connected City/country-wise by using below DAX.
Total User Connected(Wireless) = CALCULATE( DISTINCTCOUNT('Posture assessment'['ENDPOINT_ID']),FILTER('Posture assessment','Posture assessment'[NAC Policy ]="Wireless"))
And my grand total and subtotal is completely wrong as compared to actual row count. Then I tried a different approach with this DAX below but no change. Total is still wrong.