Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Division result categorization with data from 2 different tables.

Hello, I have the following tables: F_NEWBUSINESS   DELIVERY_DATE ACCT_ID MAIN_DEALER_CODE 31/01/2023 1 A 31/01/2023 2 A 31/01/2023 3 B 28/02/2023 4 C 28/02/2023 5 ...
Need Help
  • rubayatyasmin's avatar
    rubayatyasmin
    2 years ago

    Hi, Anonymous 

     

    try this one. 


    Count Dealers FP <20% =
    CALCULATE(
    COUNTROWS(F_NEWBUSINESS),
    FILTER(
    ALL(F_NEWBUSINESS),
    [Dealer Fin Pen] < 0.2
    )
    )

    Count Dealers FP 20-40% =
    CALCULATE(
    COUNTROWS(F_NEWBUSINESS),
    FILTER(
    ALL(F_NEWBUSINESS),
    [Dealer Fin Pen] >= 0.2 && [Dealer Fin Pen] <= 0.4
    )
    )

    Count Dealers FP >40% =
    CALCULATE(
    COUNTROWS(F_NEWBUSINESS),
    FILTER(
    ALL(F_NEWBUSINESS),
    [Dealer Fin Pen] > 0.4
    )
    )

rubayatyasmin's avatar
rubayatyasmin
Community Champion
2 years ago

Hi, Anonymous 

 

try this one. 


Count Dealers FP <20% =
CALCULATE(
COUNTROWS(F_NEWBUSINESS),
FILTER(
ALL(F_NEWBUSINESS),
[Dealer Fin Pen] < 0.2
)
)

Count Dealers FP 20-40% =
CALCULATE(
COUNTROWS(F_NEWBUSINESS),
FILTER(
ALL(F_NEWBUSINESS),
[Dealer Fin Pen] >= 0.2 && [Dealer Fin Pen] <= 0.4
)
)

Count Dealers FP >40% =
CALCULATE(
COUNTROWS(F_NEWBUSINESS),
FILTER(
ALL(F_NEWBUSINESS),
[Dealer Fin Pen] > 0.4
)
)

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello rubayatyasmin ,

 

Seems promising, but thanks to this I have found out, that I have some "." as main_dealer_codes in the data which is giving me problems to calculate the metric due to text to true or false evaluation raising an error, as soon as I solve this, I will let you know if it worked or not.

Thanks a lot and happy new year! 🙂