Forum Discussion

varelapablo90's avatar
varelapablo90
Icon for Helper II rankHelper II
4 years ago
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 ...
  • BeaBF's avatar
    BeaBF
    4 years ago

    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's avatar
varelapablo90
Icon for Helper II rankHelper II
4 years ago

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's avatar
BeaBF
Icon for Super User rankSuper User
4 years ago

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's avatar
    varelapablo90
    Icon for Helper II rankHelper II
    4 years ago

    Got solved when deleting the relationship :S

     

    Thank you very much