Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Good evening, again.
In the database that I have been provided with to make a panel on marketing campaigns there are 5 columns with values " 0 and 1 ", which mean respectively " Not Accepted and Accepted ".
To proceed to get the sum of the values 0 and 1 create a dimensional table for each campaign from "Specify data" and put the following columns
- Campaign acceptance (in two lines): 0 and 1,
- Acceptance group: "Not accepted and accepted", and
- Status: Negative and Positive
Then perform the following DAX measurements for each of the campaigns:
- Average Campaign Acceptance 1 = AVERAGE('Th_Campañas'[Aceptación_Campaña 1])
- Total Campaign Acceptance 1 = CALCULATE([Total Customers],'D_Aceptación_Campaña 1'[Status] = "Positive" )
Thank you
Hello, good morning.
First thank you for answering my problem.
In the campaign panel I have put several cards to verify the sum of each of the campaigns "Accepted and not accepted" and each one of them perfectly adds the number of customers, but when I made the graphs I kept getting the same error, until I have already seen that if I put these totals first on the Y axis I would get it right, but putting "Status" on the X-axis is when the error arises, so I think the problem must come from there.
Thank you so much for everything
Attached screen
Hi @Syndicate_Admin ,
Please try below steps:
1. Verify DAX Measures: Double-check the DAX measures you've created for any logical errors or misreferences. Ensure that the 'Status' column is correctly categorized in your dimensional table and that the measures are accurately calculating the totals based on this categorization.
2. Chart Setup: When setting up your chart, ensure that the 'Status' column is placed on the Axis (usually the X-axis for bar charts) and that your measure for Total Acceptance and Total Rejection is placed in the Values area. This setup should theoretically split the data into two categories based on the 'Status' and display the respective sums.
3. Review Chart Type: Some chart types may not display the data as expected based on their design. Consider trying different chart types (e.g., stacked bar chart, clustered column chart) that might better represent the categorization and aggregation you're aiming for.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
87 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |