Count Percent greater than 10

[EWBI]

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?

[EWBI · Accepted solution]

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! 

[Anonymous]

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

[VahidDM]

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/

[EWBI]

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 ))).

[Anonymous]

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.

[EWBI]

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.

[EWBI]

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!

[VahidDM]

@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/

[Whitewater100]

Hi:  -assuming your measure is [percentage],

Can you start with 

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

Then sum up this column?