How to simply sum counts?

[jcatch7]

I really new to power bi and still learning the fundamental of DAX

I have a table and list of rows of data  and I am  trying to get a SUM of the count of text. Everytime I try and add a measure the sum is incorrect.

I have tried everything from Keep Filters to ALL etc. I am trying to get % of the grand total like the attached excel spreadsheet. I exported this data set from power bi. I am trying to recreate what I can create in pivot table in a matrix table but each formula I try to use seem to ignore filters on my visual. Excel Example  

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Ratio: =
VAR _currentcondition =
    COUNTROWS ( Data )
VAR _allcondition =
    CALCULATE ( COUNTROWS ( Data ), REMOVEFILTERS () )
RETURN
    DIVIDE ( _currentcondition, _allcondition )

[HotChilli]

If you drag agreementdraftname and Count of franchiseeagreementstatusname on to a table visual , you can make the second one have an option of Show Value as -> percent of grand total (You set this in the field values well where you select the aggregation). So this will be a table visual.

If you want it like the attached excel sheet, use a matrix visual