Hi Team,
I amd new to powerbi. I want to calculate average of customer excluding category 
Hi @Sriku ,
Do you want to create a date slicer to control the number of customer?
If yes, you can add the order data in the slicer and click the date you need.
If it doesn’t meet your requirement, could you please show us the exact expected result based on the table that you have shared?
It will be helpful if you can show us the exact expected result based on the tables.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
there is average sales calculated in the each transcation level.
|
After doing pivot I need to average the average sales. then count how many customer are good or bad.
Hi @Sriku ,
We can create a good or bad column, then create two measures to meet your requirement.
1. Create a good or bad column.
Column =
var _ave = CALCULATE(AVERAGE('Table'[Sales]),FILTER('Table','Table'[Customer Name]=EARLIER('Table'[Customer Name])))
return
IF(
_ave>=150,"Good","Bad")
2. Then create good count and bad count measures.
Good count =
CALCULATE(DISTINCTCOUNT('Table'[Customer Name]),FILTER('Table','Table'[Column]="Good"))
Bad count =
CALCULATE(DISTINCTCOUNT('Table'[Customer Name]),FILTER('Table','Table'[Column]="Bad"))
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.
Thanks for your prompt response. I think you have done almost. I want to count distinct customer falling under Good and bad.
So based on any filter it should show distinct customer as pie chart.
Hope this is clear.
Hi @Sriku ,
If you want to display the pie chart, there are two ways.
The first way is add the two measures in pie chart value.
The second way is add the distinct customer name in value and add the good or bad column in Details.
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.
Hi @Sriku ,
Do you want to create a date slicer to control the number of customer?
If yes, you can add the order data in the slicer and click the date you need.
If it doesn’t meet your requirement, could you please show us the exact expected result based on the table that you have shared?
It will be helpful if you can show us the exact expected result based on the tables.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
| Row ID | Order ID | Order Date | Ship Date | Ship Mode | Customer ID | Customer Name | Segment | Country/Region | City | State | Postal Code | Region | Product ID | Category | Sub-Category | Product Name | Sales | Quantity | Discount | Profit | Avg Sales | H/M/L |
| 1 | CA-2018-152156 | 11/8/2018 | 11/11/2018 | Second Class | CG-12520 | Claire Gute | Consumer | United States | Henderson | Kentucky | 42420 | South | FUR-BO-10001798 | Furniture | Bookcases | Bush Somerset Collection Bookcase | 261.96 | 2 | 0 | 41.9136 | =U2/R2 | Low |
| 2 | CA-2018-152156 | 11/8/2018 | 11/11/2018 | Second Class | CG-12520 | Claire Gute | Consumer | United States | Henderson | Kentucky | 42420 | South | FUR-CH-10000454 | Furniture | Chairs | Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back | 731.94 | 3 | 0 | 219.582 | 0.3 | Low |
| 3 | CA-2018-138688 | 6/12/2018 | 6/16/2018 | Second Class | DV-13045 | Darrin Van Huff | Corporate | United States | Los Angeles | California | 90036 | West | OFF-LA-10000240 | Office Supplies | Labels | Self-Adhesive Address Labels for Typewriters by Universal | 14.62 | 2 | 0 | 6.8714 | 0.47 | Low |
| 4 | US-2017-108966 | 10/11/2017 | 10/18/2017 | Standard Class | SO-20335 | Sean O'Donnell | Consumer | United States | Fort Lauderdale | Florida | 33311 | South | FUR-TA-10000577 | Furniture | Tables | Bretford CR4500 Series Slim Rectangular Table | 957.5775 | 5 | 0.45 | -383.031 | -0.4 | Medium |
| 5 | US-2017-108966 | 10/11/2017 | 10/18/2017 | Standard Class | SO-20335 | Sean O'Donnell | Consumer | United States | Fort Lauderdale | Florida | 33311 | South | OFF-ST-10000760 | Office Supplies | Storage | Eldon Fold 'N Roll Cart System | 22.368 | 2 | 0.2 | 2.5164 | 0.1125 | Low |
| 6 | CA-2016-115812 | 6/9/2016 | 6/14/2016 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | United States | Los Angeles | California | 90032 | West | FUR-FU-10001487 | Furniture | Furnishings | Eldon Expressions Wood and Plastic Desk Accessories, Cherry Wood | 48.86 | 7 | 0 | 14.1694 | 0.29 | Medium |
| 7 | CA-2016-115812 | 6/9/2016 | 6/14/2016 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | United States | Los Angeles | California | 90032 | West | OFF-AR-10002833 | Office Supplies | Art | Newell 322 | 7.28 | 4 | 0 | 1.9656 | 0.27 | Low |
| 8 | CA-2016-115812 | 6/9/2016 | 6/14/2016 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | United States | Los Angeles | California | 90032 | West | TEC-PH-10002275 | Technology | Phones | Mitel 5320 IP Phone VoIP phone | 907.152 | 6 | 0.2 | 90.7152 | 0.1 | Medium |
| 9 | CA-2016-115812 | 6/9/2016 | 6/14/2016 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | United States | Los Angeles | California | 90032 | West | OFF-BI-10003910 | Office Supplies | Binders | DXL Angle-View Binders with Locking Rings by Samsill | 18.504 | 3 | 0.2 | 5.7825 | 0.3125 | Low |
| 10 | CA-2016-115812 | 6/9/2016 | 6/14/2016 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | United States | Los Angeles | California | 90032 | West | OFF-AP-10002892 | Office Supplies | Appliances | Belkin F5C206VTEL 6 Outlet Surge | 114.9 | 5 | 0 | 34.47 | 0.3 | Medium |
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.
