Calculate % of value occurrences for each date

[samue_an]

Hi All, wonder if you can help with a Dax solution, I've got 2 columns, 1 date, second Answer, is values that only have 2 variants, I.e Yes or No

I need to transform the data to a date column, %yes column and %no column

Maybe I need to pivot out three 2 columns but cannot figure it out, help will be appreciated

[v-easonf-msft]

Hi , @samue_an 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread.
More people will learn new things here. If you haven't, please feel free to ask.

Best Regards,
Community Support Team _ Eason

[Ashish_Mathur · Accepted solution]

Hi,

1. Create a Calendar Table and build a relationship from the Date column of the Data Table to the Date column of the Calendar Table
2. To your visual, drag the Date field from the Calendar Table and Answer field from the Data Table
3. Write this measure

Measure1 = COUNTROWS(Data)/CALCULATE(COUNTROWS(Data),ALL(Data[Answer]))

Format Measure1 as a %.

Hope this helps.

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example.

if you need % of the total then

countrows(Table)/calculate(countrows(Table),all(Table))

Appreciate your Kudos.