Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
hope you can help me out. I have following data:
Customer Table
CRM Table
Turnover Table
the CRM and Turnover are linked through Customer ID to the Customer Table
Now I need to calculate the Turnover for customer were not visited this year.
I already calcualted the
1. number of customers
3. Sales for the customer in a year
So how can i build up a formula ? I tried with an if-function: if(number of visits<=0;Sales;0) --> it turns the correct value, but the Total Sum field in the table is showing 0, But i need the total Sales value for those customers that were not visited yet.
any idea?
Regards,
Anastasija
Solved! Go to Solution.
Hi @ratri
Please add a new measure instead:
Measure = SUMX(Customer,[Calculate Sales for no visits])
Hi @ratri
You might consider creating pbix file that will contain some sample data, upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.
Hi,
i created an example. Hope you can download it in DropBox:
https://www.dropbox.com/s/2oooowkph8q5rld/Example%20issue.pbix?dl=0
Ratri
Hi @ratri
Please add a new measure instead:
Measure = SUMX(Customer,[Calculate Sales for no visits])
Hi,
hasonavlue referst to column. But i have no column that is indicating the number of visits. i have only a measure and with measure HASONVALUE is not working.
BG,
Ratri
User | Count |
---|---|
121 | |
69 | |
66 | |
56 | |
52 |
User | Count |
---|---|
181 | |
85 | |
67 | |
61 | |
53 |