Customer count and exception as per customer product portfolio
## Problem Description I'm trying to create a measure that counts customers with no sales or with sales based on "Customer_portfolio" . However, my current measure isn't producing the expected results when used in a visual with these attributes. ## Data Model I have three main tables: 1. **Customer_Portfolio** - Customer Code - Product Code 2. **Customer_Master** - Customer Code - Depot - Route - Area - Customer Type - Classification 3. **Sales fact table** - Customer Code - Product Code - Sales Date - Sales Amount Relationships: - Customer_Portfolio[Customer Code] -> Customer_Master[Customer Code] - Customer_Portfolio[Product Code] -> Product Master [Product Code] - Sales fact table[Customer Code] -> Customer_Master[Customer Code] - Sales fact table[Product Code] -> Product Master [Product Code] ## Current Measure Customers with Zero Gross Sales = CALCULATE( COUNTROWS( FILTER( ADDCOLUMNS( VALUES(Customer_Portfolio[Customer Code]), "GS", CALCULATE([Gross Sales]) ), [GS] = 0 ) ), ALLEXCEPT(Customer_Master) ) ``` ## Gross Sales Measure Gross Sales = SUM(Sales fact table[Sales Amount]) ## Expected Behavior When I use this measure in a table visual with attributes from the Customer_Master table (like Depot, Route, etc.), I expect to see the count of customers with zero sales for each category of the selected attribute. ## Actual Behavior The measure doesn't show values against each attribute category as expected. It's not clear if the measure is calculating correctly or if there's an issue with how it's interacting with the visuals. ## Sample Data Here's some sample data to illustrate the problem: **Customer_Portfolio** | Customer Code | Product Code | |---------------|--------------| | C001 | P001 | | C001 | P002 | | C002 | P001 | | C003 | P003 | **Customer_Master** | Customer Code | Depot | Route | Customer Type | |---------------|-------|-------|---------------| | C001 | D1 | R1 | Retail | | C002 | D1 | R2 | Wholesale | | C003 | D2 | R3 | Retail | **Sales fact table** | Customer Code | Product Code | Sales Amount | |---------------|--------------|--------------| | C001 | P001 | 100 | | C001 | P002 | 0 | | C002 | P001 | 0 | | C003 | P003 | 0 | ## Questions 1. Why isn't my measure showing values for each attribute category? 2. How can I modify the measure to correctly count customers with zero sales by different attributes? 3. Is there a better way to structure this measure or my data model to achieve the desired result? Any help or guidance would be greatly appreciated!
Visualise distributions with pre-summarised data
G’day everyone, New user of Power BI and first-time poster. I want to know how I can create a visualisation of key distribution statistics (e.g. minimum, first quartile, medium, third quartile and maximum) using data that has already been summarised? For example, consider the data example in the first screenshot below. I can use excel to show these statistics as a box and whisker plot that dynamically responds to the filters I’ve applied (see second screenshot below). Is it possible to do something similar in Power BI? The only non-negotiable constraint is that the data is already summarised (like the example in the first screenshot). The visualisation doesn’t have to be a box and whisker plot, just something that highlights the distribution. The structure of the data set can also be different (e.g. the summary statistics can be restructured as columns rather than rows as they are in the example attached). Thanks in advance for all your help! PS: This forum would be even better if members could post files so responders had access to sample data or other reference material.Plotting a Graph
hi everyone - Objective: Apply the total cost for each month that the project is active. For example, Project A: Jan-2020: $1000 Feb-2020: $1000 Mar-2020: $1000 Apr-2020: $0 Project Cost Start Date End Date A $1,000 1/1/2020 3/31/2020 B $5,000 1/1/2021 5/5/2021 C $6,000 3/3/2020 3/5/2020
Is there a limit to the number of people on a subscription distribution?
Is there a limit to the number of people that can be subscribed to a dashboard subscription? It appears that I have reached a limit of people that I can subscribe to a dashboard. When I try to add more people to the distribution, the "save and close" button spins for a moment and returns; no edits are saved; no error messages appear.
distribution of calculated measure
Hi all, i dont even know if the subject title fits to what i am actually looking for, but i will try to explain here more in details. i have model contains 4 different tables/databases: calendar table, products list, customers list and sales table of customers and products bought by them monthly. i already have measures that: 1. counts num. of products 2. counts num. of customers I wish to present a clustered column chart which counts how many customers have bought each number of products from 1 to max products i have. for example, lets say i have 10 products: i wish to get the above result. thanks in advance, Amit
