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

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

    varelapablo90  both threshold and amount are numbers?

     

    Can you make an example with a subset? It seems very strange... 

     

    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.