Hi @NipponSahore,
I'm sorry for misunderstand your requirement before. Now you could follow the steps below to get your desired output.
1. Create a calculated table to get the all customers and create the relationship of the two tables.
Table = VALUES(Sheet22[Customer ])
2. Create the measure in your original table.
Measure = var a= COUNT(Sheet22[Amount ]) return IF(ISBLANK(a),0,1)
3. Then you could ceate the matrix with the new Customer you created in the Table as Rows and Item sold as Columns , the measure as Values.
You could see the difference with the picture below.
For reference, you could have a look at my pbix file which has been attached.
Hope this can help you!
Best Regards,
Cherry
Hi @NipponSahore,
Do you want to have the output below?
If it is your requirement, you only need to create the matrix with the Customer as Row, Item sold as Column and Amount as Values.
If I misunderstood your case, please let me know and show your expcted output, so that we can help further investigate on it?
Best Regards,
Cherry
Hi @NipponSahore,
I'm sorry for misunderstand your requirement before. Now you could follow the steps below to get your desired output.
1. Create a calculated table to get the all customers and create the relationship of the two tables.
Table = VALUES(Sheet22[Customer ])
2. Create the measure in your original table.
Measure = var a= COUNT(Sheet22[Amount ]) return IF(ISBLANK(a),0,1)
3. Then you could ceate the matrix with the new Customer you created in the Table as Rows and Item sold as Columns , the measure as Values.
You could see the difference with the picture below.
For reference, you could have a look at my pbix file which has been attached.
Hope this can help you!
Best Regards,
Cherry
I got a requirement where i have the data available in the following format
| Customer | Item sold | Item type | Amount |
| Customer1 | Item1 | Type 1 | 1 |
| Customer2 | Item2 | Type 2 | 1 |
| Customer3 | Item4 | Type 2 | 1 |
| Customer4 | Item2 | Type 2 | 1 |
| Customer5 | Item3 | Type 1 | 1 |
| Customer6 | Item4 | Type 2 | 1 |
| Customer7 | Item3 | Type 1 | 1 |
| Customer8 | Item1 | Type 1 | 1 |
| Customer9 | Item2 | Type 2 | 1 |
| Customer10 | Item4 | Type 2 | 1 |
| Customer1 | Item2 | Type 2 | 1 |
| Customer2 | Item3 | Type 1 | 1 |
| Customer3 | Item4 | Type 2 | 1 |
| Customer4 | Item3 | Type 1 | 1 |
| Customer5 | Item1 | Type 1 | 1 |
| Customer6 | Item2 | Type 2 | 1 |
| Customer7 | Item4 | Type 2 | 1 |
| Customer8 | Item2 | Type 2 | 1 |
| Customer9 | Item3 | Type 1 | 1 |
| Customer10 | Item4 | Type 2 | 1 |
My requriement is to visualize data in a matrix and allow to slice data on Item type (Type1/Type2), However still show all the customers where sale is not made for said item type.
Example output on slicing on Item Type = Type 1
| Customer | Item 1 | Item3 |
| Customer1 | 1 | |
| Customer2 | 1 | |
| Customer3 | ||
| Customer4 | 1 | |
| Customer5 | 1 | 1 |
| Customer6 | ||
| Customer7 | 1 | |
| Customer8 | 1 | |
| Customer9 | 1 | |
| Customer10 |
Similaryly, slicing on Item Type = Type 2
| Customer | Item 2 | Item4 |
| Customer1 | 1 | |
| Customer2 | 1 | |
| Customer3 | 1 | |
| Customer4 | 1 | |
| Customer5 | ||
| Customer6 | 1 | 1 |
| Customer7 | 1 | |
| Customer8 | 1 | |
| Customer9 | 1 | |
| Customer10 | 1 |
Please show me the light. 
Helpful resources
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
