The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Sorry if this is a report but I have searched endlessly for a clear answer.
I have to report on an open rate by month.
I expect to see an open rate report by month which reacts to demographic slicers.
My dataset is a large datadump that has events (Opens and Deliveries within the same line)which are timestamped. I've created the Summarized table that returns to me the open rate by month, and linked them by their PK, no problem.
The issue when we want to see the open rates within a certain demographic the values don't change. They're not recalculating. So if prior to selecting a slicer the open rate is 40% and 60% between May and June, those values remain no matter what is selected, even after the table relationships are correctly applied.
I did some hunting for calculated tables but have not seen an example where this works.
Any help would be greatly appreciated.
-Chris
Hi @Chrisdonovan11 ,
More details will be much helpful.
If it is convenient, could you share some data sample or screenshots to describe your scenario better so that we could help further on it?
Please refer to this blog how to get your question answered quickly.
Best Regards,
Cherry
Sure, I didn't see a place to attach a pbx but hopefully this works.
Below is the data set.
ContactID | ContactState | CustomerType | ProgramName | Entered | Engaged | Purchased |
1 | MI | Preferred | 1st Program | 5/1/2019 | 5/2/2019 | |
2 | MI | Edge | 2nd Program | 5/2/2019 | 5/3/2019 | 5/4/2019 |
3 | MA | Other | 1st Program | 5/3/2019 | 5/4/2019 | |
4 | MA | Preferred | 2nd Program | 5/4/2019 | 5/5/2019 | 5/6/2019 |
5 | CA | Edge | 1st Program | 5/5/2019 | 5/6/2019 | |
6 | CA | Other | 2nd Program | 5/6/2019 | ||
7 | NY | Preferred | 1st Program | 5/7/2019 | 5/8/2019 | 5/9/2019 |
8 | NY | Edge | 2nd Program | 5/8/2019 | ||
9 | NY | Other | 1st Program | 5/9/2019 | ######## | |
10 | NY | Preferred | 2nd Program | 5/10/2019 | ######## | 5/12/2019 |
When I create visuals I hope to highlight the number of contacts per program and the open rate per program (a table with the screenshot below)
What I get is a table that won't change line values (from the new table above) when applying slicers.
Seems like this isn't possible.
Hi @Chrisdonovan11 ,
By my tests, I'm afraid that we cannot achieve your desired output based on your summarize table.
Why not create the measure directly?
You could create the measure like below.
Measure 3 = VAR a = CALCULATE ( COUNTX ( 'Table2', 'Table2'[Engaged] ), FILTER ( 'Table2', 'Table2'[ProgramName] = MAX ( 'Table2'[ProgramName] ) ) ) VAR b = CALCULATE ( COUNTX ( 'Table2', 'Table2'[Entered] ), FILTER ( 'Table2', 'Table2'[ProgramName] = MAX ( 'Table2'[ProgramName] ) ) ) RETURN DIVIDE ( a, b )
Best Regards,
Cherry
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 |
---|---|
141 | |
109 | |
108 | |
76 | |
63 |
User | Count |
---|---|
270 | |
129 | |
123 | |
100 | |
92 |