The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I am trying to create a chart which should show the engagement percentage trend in a chart. It should take a measure in y-axis for percentage and event_date in x-axis with YearMonth.
The table has user_id, event_date, event_name.
The measure for y-axis is essentially a DIVIDE function with DISTINCTCOUNT of user_id for a specific month in the numerator and the denominator should be DISTINCTCOUNT of user_id till the end of the specified month.
I am able to create the numerator but unable to create the denominator.
#Numerator
Hi @SivaRamaKrishna ,
Did some_bih's answer help you? Have you tried his syntax?
If it helped you, please accept it as the solution. This will be of great help to other users who have similar problems as you.
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Hi @SivaRamaKrishna it is not easy to propose possible solution without model and other details.
Still, try v2 below
TotalU_v2 =
VAR StartDate = DATE(2018, 1, 1)
RETURN
CALCULATE(
DISTINCTCOUNT(engagement[user_id]),
FILTER(engagement,
engagement[event_date] > StartDate &&
engagement[event_date] <= Date(2024, 05, 31)
)
)
Proud to be a Super User!