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 ...
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 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.
Got solved when deleting the relationship :S
Thank you very much