Group numbers

Hi  jeroend ,

Here are the steps you can follow：

Graphs to visualize how many invoices are above the value 50.000”:

1. Create measure.

Flag =
IF(
    MAX('Table'[Value]) >500000,1,0)

2. Place [Flag] in Filters, set is=1, apply filter.

3. Result:

Only values greater than 500,000 are displayed

How many invoices are above a certain amount and this in % of total invoices：

1. Create measure.

% of total invoices =
var _over_allcount=COUNTX(FILTER(ALL('Table'),
    'Table'[Value]> 500000),[Number])
var _totalinvoices=COUNTX('Table','Table'[Number])
return
DIVIDE(_over_allcount,_totalinvoices)

2. Result：

How many invoices of the have a po number in the summarry column and this in relation of the total invoices：

1. Create measure.

IF_ponumber =
var _mid=MID(MAX('Table'[Summary]),5,1)
return
IF(
    _mid <> "-",1,0)

summarry% =
var _countponumber=COUNTX(FILTER(ALL('Table'),[IF_ponumber]=1),[Number])
var _countall=COUNTX('Table','Table'[Number])
return
DIVIDE(_countponumber,_countall)

2. Result.

Best Regards,

Liu Yang

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