Daily percent of Yes value

[Anonymous]

Hi,

I have a worksheet containing three columns.

In the first one, I have customer numbers, on the second one there's a value Yes/No and on the third column you can see the dates when the value y/n was recorded.

I would like to calculate the daily percent value of those customers recorded with "yes" and present it later on the report.

Is there any chance to get it done using the measure? Could you please help me with that? 

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please check the below picture and the sample pbix file's link, whether it is what you are looking for.

Customers Y Percentage =

DIVIDE (

CALCULATE ( DISTINCTCOUNT ( Data[Customer] ), Data[Value] = "y" ),

DISTINCTCOUNT ( Data[Customer] )

)

https://www.dropbox.com/s/zftn72dfzst84e6/matpat.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[amitchandak]

@Anonymous , You can create a measures like

percent = divide(calculate(count(Table[customer number]),filter(Table, Table[yes/No] ="Yes") ),count(Table[customer number]))

With date table you can also use time intelligence

This Day = CALCULATE([percent], FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))
Last Day = CALCULATE([percent], FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])-1))
Last Day = CALCULATE([percent], previousday('Date'[Date]))

diff =[This Day] - [Last Day]