Need to get % according to EPIC Name for each month based on count of EPIC names

[Anonymous]

Hi,

I have a requirement to show the EPIC name(we have 3 EPIC names) in % for each month wise based on EPIC's count

I got the correct out in 100% Stacked column chart like below

However I need to show the same % in table visual based on EPIC Names count (due to difficult to see the data for less values i.e Yellow ) 

I am expecting the DAX or any other logics for the same

out put should be like below bolded one ( I am just manually given for Jan month . need to get out like that for all the months)

January  -   All Other EPICS   - 31  - 65.96%

January  -  QB BAU/CI EPIC  - 12 - 25.53%               

January   - QB Tech Debt   - 4 -    8.51%

Thanks in advance 😊

[amitchandak]

@Anonymous , Based on what I got. Hope you have meausre EPIC Names count

new measure =

Divide([EPIC Names count], calculate([EPIC Names count], removefilters(Table[Month])))

[Anonymous]

Hi Amit,

Thank you for your replay..

I just used your DAX formula however I am getting the 100% for all like below which is not correct one.

[SpartaBI · Accepted solution]

@Anonymous 

Measure =
DIVIDE (
    [EPIC Names count],
    CALCULATE (
        [EPIC Names count],
        REMOVEFILTERS ( Table[New EPIC_Name])
    )
)

Showcase Report – Contoso By SpartaBI