Column % of another column

[AMBP1973]

Hello,

I used a Quick MEasure to get a Year to Date Total for a Date column "Approval Date", as below. This returned a result of 18 out of a total of 57 Rows.  However, I am seeking to also get the % of what 18 (YTD count) is of the total 57 rows in the same column. I have tried many ways i.e. DIVIDE, Percentage diffrence etc.. with no success, any assitance with the correct DAX expression would be much appreciated 🙂

Count of Approval Date YTD =

IF(

    ISFILTERED('E&T Document Status Tracker'[Approval Date]),

    ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),

    TOTALYTD(

        COUNTA('E&T Document Status Tracker'[Approval Date]),

        'E&T Document Status Tracker'[Approval Date].[Date]

[Anonymous]

Hi @AMBP1973 ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[AMBP1973]

I copied exactly what you provided, but it still gives me this on the card

[Dangar332]

hi, @AMBP1973 

try below one

count% =  
var  a =

 TOTALYTD(

        COUNTA('E&T Document Status Tracker'[Approval Date]),

        'E&T Document Status Tracker'[Approval Date])
var b =  countrows (all('E&T Document Status Tracker'[Approval Date]))
var c = divide (a,b)

return

1- c

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

[Dangar332]

These not gonna help me to understand your scenario.

 you check  my solution like first check  output of var a=

                                   then           second check output of var b =

and then calculate percentage  

OR

provide more data to check where it trouble

[AMBP1973]

Hi @Dangar332. Thankyou so much for your assistance. This worked, however it gave me the opposite % of what I am seeking. It returned 62%, whereas it is more like 38%? Is there a ay to adjust the DAX to accomodate.? Thankyou in advance

[Dangar332]

hi, @AMBP1973 

you want  percentage like 18/57 as you mention above or something else?

[Dangar332]

provide sample data and what you want

[AMBP1973]

Count of YTD Dates % of total.

Thankyou

[Dangar332]

hi, @AMBP1973 

use below measure 

count% =  
var  a =

 TOTALYTD(

        COUNTA('E&T Document Status Tracker'[Approval Date]),

        'E&T Document Status Tracker'[Approval Date])
var b =  countrows (all('E&T Document Status Tracker'[Approval Date]))
return 
divide (a,b)

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

[AMBP1973]

@Dangar332 Sorry if I haven't been clear. I am seeking what % of 57 is 18? Therefore around 38% as the data currently stands. Thanks for your assistance

[Dangar332]

my solution give you exactly what you want 

18:57*100 =

(18*100):57 =

1800:57 = 31.58%