Forum Discussion
varelapablo90
Helper II
Helper IIHelp - 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 ...
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.
BeaBF
Super User
Super User
varelapablo90Helper II
Helper IILike this? These fields are in my main raw data table T_RawData_Azure
- BeaBF
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
Worked perfectly, thank you!What if I want to also have the column with the values in eur too?
- 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.