Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
Hi,
I have what seems to be a simple problem, however I cannot find a solution.
Here is a simplified explantion:
I have a table with people and a table with cars.
Each person can hold zero to many cars.
Here is the content of the both merged together:
I would like to show how many people have a specific car and in teh same graph also to show how many people don't have a car, however when I create the graph, I get only the number of people per car and I don't have an empty row to count how many people don't have car:
Here is what I wanted to get:
Here is how the visual fields look like:
I am sure that there is a simple solution, but I cannnot figure it out.
I would appriciate the help.
Here is a link to the pbi if it will help to provide a solution in the exmaple file.
Thanks,
Yaron
Solved! Go to Solution.
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://dropmefiles.com/ecD7H



Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://dropmefiles.com/ecD7H



Thank you Ahmedx!
This works well.
| Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Thanks CNENFRNL,
Just to make sure that I understand - in your case the number of empty will show in the total and you just renamed it.
This means that this value will not show up in a graph.
Thanks.