Help! Unable to calculate percentage of grand total of rows within a column

[pparke]

Inexpereinced power bi user here.

I have a column named 'pandemic related leave'. Value of 1 relates to leave request being pandemic related, otherwise no value. I am wanting to display the percentage of pandemic related leave  i.e 44 rows with 1, total rows of 9840. Percentage should be .44%.

When i select show value as percentage of grand total it remains at 100%. 

Any ideas?

TIA

[amitchandak]

@pparke ,

Try like

divide(calculate(countrows(filter(Table,table[pandemic related leave]=1))),calculate(countrows(Table),all(Table)))

Mark this as %.

[pparke]

I tried this and get error message below:

The syntax for 'Yes' is incorrect. (DAX(divide(calculate(countrows(filter(Pandemic Yes,Pandemic Yes[Pandemic Yes]=1))),calculate(countrows(Pandemic Yes),all(Pandemic Yes))))).

[v-jayw-msft]

Hi @pparke ,

Can you share some sample data? It's hard to write formula with out any sample data.

Best Regards,

Jay