topic Re: Column % of another column in DAX Commands and Tips

Column % of another column

AMBP1973 — Wed, 18 Oct 2023 09:56:42 GMT

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]

Re: Column % of another column

Dangar332 — Wed, 18 Oct 2023 10:16:15 GMT

provide sample data and what you want

Re: Column % of another column

AMBP1973 — Wed, 18 Oct 2023 10:28:32 GMT

Count of YTD Dates % of total.

Thankyou

Re: Column % of another column

Dangar332 — Wed, 18 Oct 2023 10:44:33 GMT

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.

Re: Column % of another column

AMBP1973 — Wed, 18 Oct 2023 10:57:29 GMT

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

Re: Column % of another column

Dangar332 — Wed, 18 Oct 2023 11:07:36 GMT

hi, AMBP1973

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

Re: Column % of another column

AMBP1973 — Wed, 18 Oct 2023 11:09:54 GMT

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

Re: Column % of another column

Dangar332 — Wed, 18 Oct 2023 11:18:46 GMT

my solution give you exactly what you want

18:57*100 =

(18*100):57 =

1800:57 = 31.58%

Re: Column % of another column

AMBP1973 — Wed, 18 Oct 2023 11:23:59 GMT

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

Re: Column % of another column

Dangar332 — Wed, 18 Oct 2023 11:31:25 GMT

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

provide more data to check where it trouble

Re: Column % of another column

Dangar332 — Wed, 18 Oct 2023 12:03:37 GMT

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

Re: Column % of another column

Anonymous — Mon, 23 Oct 2023 09:03:00 GMT

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