Forum Discussion
Constant value for denominator using measure
Hello All, I am working with data set where I have youth_ID, start_date, end_date, region (table with duplicate youth_id). I have sliclers for start_date, end_date, region. Now, I want to create ...
amitchandak
Super User
Super Usersaurabhpore , Try like
num = CALCULATE(DISTINCTCOUNT('part-2_YA_engagement'[youth_id]))
den = CALCULATE(DISTINCTCOUNT('part-2_YA_engagement'[youth_id]),ALL('part-2_YA_engagement'))
per = num/den
hello,
I tried that approach but it gives me total unique youths rather than unique youth count for selected slicers.
- amitchandak
saurabhpore ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. with couple of use case
Hello,
Please follow below link to download the pbix file.
amitchandak please let me know if you find any solution.