Percent of Total by Filtered Value

[Anonymous]

Hello,

I am trying to figure out the percentage of total people who had >=10 Units Total for the given month. 

So in this case there are 3 Total people. In September, 2 out of 3 have total sum of units greater than 10. So the percentage would = 2/3 = 66% 

August would be 1 out of 3 people had units >=10 so the percentage would be 33%

I am looking for a measure or something to be able to throw on a card and when the page is filtered by month it shows the percent 

Any help is greatly appreciated! 

[v-chenwuz-msft · Accepted solution]

Hi @Anonymous ,

Try this measure:

Percent of Total =
DIVIDE (
    COUNTROWS (
        FILTER (
            ALL ( 'Table' ),
            [Date] = SELECTEDVALUE ( 'Table'[Date] )
                && [Unites] >= 10
        )
    ),
    COUNTROWS (
        FILTER ( ALL ( 'Table' ), [Date] = SELECTEDVALUE ( 'Table'[Date] ) )
    )
)

Result

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

I have assumed you have a Calendar Table with a relationship from the Date column of your Data Table to the Date column of the Calendar Table.  In the slicer select a Year and Month Name.  Try this measure

Measure 1 = COUNTROWS(FILTER(VALUES(Data[Client Name]),[Units]>=10))

Measure 2 = divide([measure1],distinctcount(data[client name]))

Hope this helps.