Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I'm new to dax, and I have created a table using this code.
Summary installation =
VAR _Table = SUMMARIZECOLUMNS('produit installé'[Netbios_Name0],'produit'[FileDescription (groups)])
return DISTINCT(_Table)
but there is a problem with it as the returned table gives me a row of netbios_Name for each file description category.
is there a way to fix this .
thanks for your help
Solved! Go to Solution.
@latrous98 , if these table have join summarize should also work
SUMMARIZ('produit installé', 'produit installé'[Netbios_Name0],'produit'[FileDescription (groups)])
or
SUMMARIZ('produit', 'produit installé'[Netbios_Name0],'produit'[FileDescription (groups)])
if these does not work
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@latrous98 , if these table have join summarize should also work
SUMMARIZ('produit installé', 'produit installé'[Netbios_Name0],'produit'[FileDescription (groups)])
or
SUMMARIZ('produit', 'produit installé'[Netbios_Name0],'produit'[FileDescription (groups)])
if these does not work
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
if I want to make a measure that does give the rows number and filter upon that , and then use it in a visual , what is the blueprint I need to follow ?
the first table 'produit installé' (installed product ) contains all the products regardless of the groupe they belong to so doing a summerizeColumn without distinct give me rows as much as there is subproduct to a given category .
but when I applied the distinct ,I get as much rows for all the groupement even though that doesn't exist to start with
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 20 | |
| 11 | |
| 10 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 31 | |
| 19 | |
| 12 | |
| 11 |