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 III 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?
Super Uservarelapablo90 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