dax for percentage

[Anonymous]

hi i am looking for dax
i have 2 measures 1 to count the request ids another to show the mtd count of request ids
i want to show the percentage of the 2 measures.
mtd count of request id = 24
count of request ids = 872
percentage  wil  be 24/872= 2.75%
how can i show by dax
i have tried this dax query but it is returning 0% 

percentage = DIVIDE ( [mtd count of request id], [count of request ids] )

[amitchandak]

@Anonymous , you can create two meausre like

MTD = CALCULATE(count(Table[request id ]),DATESMTD('Date'[Date]))
All = CALCULATE(count(Table[request id ]),all('Date'[Date]))

make sure you use date tbale

then % = divide([MTD],[All])

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[Anonymous]

hi
i have tried ur dax but the percentage is wrong
24/872 = 2.75 which i need to get but it is returning 72.73%

[v-easonf-msft]

Hi, @Anonymous 

Could you please tell me whether your problem has been solved?

For now, there is no content of description in the thread. If you still need help, please share a sample file for testing.

Best Regards,
Community Support Team _ Eason

[Anonymous · Accepted solution]

% = DIVIDE([sub],[MTD requestid])

[amitchandak]

@Anonymous , Can you share your formula

if possible

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.