Forum Discussion
Solved
Help - Dax Threshold
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?
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.
9 Replies
Like this? These fields are in my main raw data table T_RawData_Azure
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.
