Forum Discussion
NEED HELP // ERROR AL CONTAR
Hi Mikaseido1,
Thank you for reaching out to us through the Microsoft Fabric Community Forum.
In addition to the response provided by Omid_Motamedise and wini_R , please find below the solution using DAX to accurately count the total number of distinct households across all territories.To achieve this, we can create a measure using the DISTINCTCOUNT function.
The DAX measure is as follows:
CountHouseholdsByTerritory = DISTINCTCOUNT(Sampledata_101220224[NumIdentificationHome])Place the Measure in the Table Visual
- Add the column to the Rows section of your table visual.
NameTerritory - Add the measure to the Values section.
CountHouseholdsByTerritory
This setup will display the distinct count of households for each territory in the respective rows and the total distinct count across all territories in the grand total row.
Please refer to the attached screenshot:
If you find this post helpful, kindly mark it as the solution to assist other members in locating it easily.
Regards,
Pavan.
- Add the column to the Rows section of your table visual.
Community SupportHi Mikaseido1,
We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.
If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.
Best regards,
Pavan