Simple DAX % Calculation

[RossTheBoss]

** EDIT ** I just had to scroll down, I didn't realize the dataset had such a large 100% list. 

The expression

 DIVIDE(COUNTROWS(FILTER(SQL, [IsOverride] = "0 OVERRIDE")), COUNTROWS(SQL))

Returns the correct % outside of any report filter context; however, when added to a filter context that subdivides this "%" by category - it returns 1.  I made sure to add decimal place in format.  Am I missing something?  Each evaluation seperately returns the correct number inside the report but not when divided.

[amitchandak]

@RossTheBoss , This will work fine for grand total

DIVIDE(COUNTROWS(FILTER(SQL, [IsOverride] = "0 OVERRIDE")), COUNTROWS(SQL))

But when you add any context the denominatoe will also change

then you might want

DIVIDE(COUNTROWS(FILTER(SQL, [IsOverride] = "0 OVERRIDE")),calculate(COUNTROWS(SQL), allselected(SQL)) )

or

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