count of days if revenue = 0 / sum of days passed in the month * 100

[jaspreet27singh]

I have two tables in data model

table one - calendar 

table two - facts

I want create a measure-  count of days if revenue = 0 / sum of days passed in the month * 100 

[v-zhouwen-msft]

Hi @Dangar332 ,thanks for the quick reply.

Hi @jaspreet27singh ,

The Table data is shown below:

Please follow these steps:
1. Use the following DAX expression to create a measure('DAY(TODAY())': Indicates how many days have passed in the month)

Measure = DIVIDE(
    CALCULATE(COUNT(Table2[Amount]),'Table2'[Amount] = 0),
    DAY(TODAY()) * 100)

2. Final output

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Dangar332 · Accepted solution]

hi, @jaspreet27singh 

try below code it might work

if revenue is measure then try below

measure=
calculate(
   count(table[date]),
   filter(
     facttable,[revenue]=0
)

if still not work then provide some sample data