Forum Discussion

RossTheBoss's avatar
RossTheBoss
Regular Visitor
5 years ago

Simple DAX % Calculation

** 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.

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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.