Forum Discussion

sdhn's avatar
sdhn
Icon for Responsive Resident rankResponsive Resident
4 years ago

Change to Number

Hi All,   I wrote some mesaures and displaying data in the percentage in the graph. Here is the code in the measure   Not Applicable % = divide(countrows(filter('Department Application','Depart...
Help appreciated
VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

Hi sdhn 

 

If you want a number, try this:

Not Applicable % =
Var _A = 
DIVIDE(
    COUNTROWS(
        FILTER(
            'Department Application',
            'Department Application'[Status of Stocks] = "NOT APPLICABLE"
        )
    ),
    COUNTROWS( 'Department Application' )
)
Return
_A*100

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/