Help - Dax Threshold

[varelapablo90]

Hello everyone

I need help with the following case.

I would like to know from my main raw data table how many of these invoices are under 50, how many under 100 (including the <50.... and so on 200, 300, etc.

Is there any possible way to create a table with a such information?

Currently I have my Threshold table with the values you see in the screen relationed to the main table on the Invoice Value field.

How could this be achieved?

[BeaBF]

@varelapablo90 can you paste your invoice value field?

Thx,

B.

[varelapablo90]

Like this? These fields are in my main raw data table T_RawData_Azure

[BeaBF · Accepted solution]

@varelapablo90 Try with this calculated column in the Threshold Table:

Colonna =

VAR THRE = Threshold[Threshold]

RETURN CALCULATE(COUNTROWS(T_RawData_Azure),T_RawData_Azure[Amount_in_EUR] <= THRE)

It returns the count of amount value in T_RawData_Azure that are less or equal to that threshold, like this:

B.

[varelapablo90]

I thought it had worked but now that I see it didnt, I have like 4 million rows in this set, numbers should be bigger, but also for example the Category 100 should include the 50. What be wrong?

[BeaBF]

@varelapablo90  both threshold and amount are numbers?

Can you make an example with a subset? It seems very strange... 

B.

[varelapablo90]

What do you mean with a subset? 

I cant figure out what is different from the solution you provided, the datatypes are both numbers and the relationship is based on Amount_in_EUR -> Threshold

[BeaBF]

@varelapablo90 the relationship is useless, try to remove it. By subset I mean taking a piece of data to understand why it doesn't work, to me it works with the data I pasted to you.

Try with Count instead of Countrows:

Colonna =

VAR THRE = Threshold[Threshold]

RETURN CALCULATE(COUNT(T_RawData_Azure[Amount_in_EUR]),T_RawData_Azure[Amount_in_EUR] <= THRE)

B.

[varelapablo90]

Got solved when deleting the relationship :S

Thank you very much

[varelapablo90]

Worked perfectly, thank you!

What if I want to also have the column with the values in eur too?