Forum Discussion
Helper IIHelp - Dax Threshold
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.
Helper IILike this? These fields are in my main raw data table T_RawData_Azure
Super Uservarelapablo90 Try with this calculated column in the Threshold Table:
- 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.
- 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