topic Re: Count Percent greater than 10 in DAX Commands and Tips

Count Percent greater than 10

EWBI — Wed, 09 Mar 2022 19:19:49 GMT

I have a table with a measure that calculates percentage. Is it possible to create another measure to count percent values greater than 10?

Or is there another way I can achieve this?

Re: Count Percent greater than 10

Whitewater100 — Wed, 09 Mar 2022 21:19:58 GMT

Hi: -assuming your measure is [percentage],

Can you start with

IF([percentage] >=.10,1, BLANK())

Then sum up this column?

Re: Count Percent greater than 10

EWBI — Wed, 09 Mar 2022 21:31:33 GMT

My Percentage measure is Previous Balance Collected divided by Previous Balance Due x10 to get the perecentage of Previous Balance Due that was collected.

% of PrevBal = 'Weekly POS Collections'[PBC div PBD]* (1)

How do I apply your example above to this measure? Or did I need to create a new measure?

Thank you so much for your input!

Re: Count Percent greater than 10

VahidDM — Wed, 09 Mar 2022 21:44:42 GMT

HI EWBI

You need to create a table in a variable with that % measure, then set a filter and countrows, try this:

Measure_Count = VAR _A = ADDCOLUMNS ( Table, "Percent", [% of PrevBal] ) VAR _B = FILTER ( _A, [Percent] > 0.1 ) RETURN COUNTROWS ( _B )

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: Count Percent greater than 10

EWBI — Wed, 09 Mar 2022 21:55:33 GMT

I get a syntax error:

The syntax for 'Table' is incorrect. (DAX(VAR _A = ADDCOLUMNS ( Table, "Percent", [% of PrevBal] )VAR _B = FILTER ( _A, [Percent] > 0.1 )RETURN COUNTROWS ( _B ))).

Re: Count Percent greater than 10

Anonymous — Thu, 10 Mar 2022 00:00:32 GMT

Hi EWBI ,

He is just giving you example, you need to modify it yourself to use it.

Try changing "Table" to "Weekly POS Collections" and [Percent] to [% of PrevBal].

Accept his answer as solution if it works to help out other people facing the same problem.

Re: Count Percent greater than 10

EWBI — Thu, 10 Mar 2022 00:11:37 GMT

Oh my gosh lol! Yes ok It worked. Thank you. I have to play with it a bit. It counts some things over 10% but not all.

Re: Count Percent greater than 10

Anonymous — Tue, 15 Mar 2022 05:46:31 GMT

Hi EWBI ,

It counts some things over 10% but not all.

If there is any filters? Could you please provide some dummy data and expected output to help us clarify your scenario?

Refer to

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Eyelyn Qin

Re: Count Percent greater than 10

VahidDM — Tue, 15 Mar 2022 22:18:46 GMT

EWBI

Can you add more details about what you want to do and the result?

Did my sample formula work?

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: Count Percent greater than 10

EWBI — Wed, 16 Mar 2022 01:02:02 GMT

Whew! That was a rough one for me! I am a newbie so please forgive.

The adivsed measure didnt work for me probably because I wasnt doing something correctly to apply it.

But Good News! I found my solution. This is what I did.

I had our report writer in EPIC add a precalculated column with the percent of dollars collected of the dollars due.

The data with the new column had the % values represented as a whole number.

So then I just had to create a measure in DAX to find numbers in that column greater than >10

Count of % >10 = CALCULATE('table'[Sum of % Prev Bal Col]>10)

This gave me a column of True and False

I then created a measue to count the True Values

Count of True Value >10% = COUNTAX(FILTER('table',[Count of % >10]=TRUE()),TRUE())

This gave me a count of rows that had a True value.

Then all I needed to do is create a percentage calculation.

Woo hoo! I probably didnt have to do all that but thats how I got it done.

Thanks for the input!