The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
This is my measure for the current output.
leads per date = CALCULATE(The enrollemnt table is a list of everyone who signed up for an event, a leads program can have multiple events.
The EE All Leads is all the leads.
Each page in the dashboard is a different event, filtred on the page.
This is my first time ever posting on a forum, if more information is needed let me know.
Thank You!
Hi @VB
please try
Thank You, with that measure this is my output.
Please try
leads per date =
VAR CurrentStart =
MAX ( 'Enrollment'[Start Date] )
VAR PreviousStart =
CALCULATE (
MAX ( 'Enrollment'[Start Date] ),
'Enrollment'[Start Date] < CurrentStart
)
RETURN
CALCULATE (
COUNT ( 'EE All Leads'[Email] ),
USERELATIONSHIP ( 'Enrollment'[Leads Program], 'EE All Leads'[Leads Program] ),
DATESBETWEEN (
'Calendar'[Date],
COALESCE ( PreviousStart, DATE ( 2022, 7, 1 ) ),
CurrentStart
)
)
Thank you @tamerj1 , I appreicate all the help! It gives me the same output as my orginal measure. This might be more complicated than I intially thought.
I noticed that you are a little bit shy to explain a little bit your data model and report, therefore, I had no option but to try to guess 😅
I understand that the date in the report is coming from Enrollment table (Start Date) and not from the date table. I can understand tgat tge problem is created due to different cardinalities between the different tables. I cannot guess enough the nature of tge relationships between the tables. A screenshot od the data model view + some sample data would greatly help to clarify the picture.
@tamerj1 Yes, it is my first time ever posting in a forum, so defently a little shy. I did create a simple dashboard with fake data to share(als found out since Im a new member I can't share it) and while doing so I realized that in that fake data dahsboard the measure works. It has the exact same relationship but less columns and less data, so something in the other columns or amount of data is causing the issue. And since I cant share the actual data, I think I'll have to figure it out on my own.
I appreicate all your help today!
@tamerj1 I made the dummy dashboard as close as I could to the orginal and it does not work how I would like anymore. It seems to be the page filter i have for events but I need that there to distinguish between the events. If you are still willing to help me that would be great!
I included two views one with all events and programs and one with just the events from one program. It wont let me create a link to share outside my organization, so I uploaded it to google drive with the link attatched.
https://drive.google.com/file/d/11ugmXuRP_eG-3qhNzxL9XbTKUwVVrdj4/view?usp=sharing
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 |
---|---|
58 | |
33 | |
20 | |
19 | |
15 |
User | Count |
---|---|
42 | |
36 | |
32 | |
23 | |
23 |