Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
64 | |
59 | |
56 |