Forum Discussion

YBavré's avatar
YBavré
Frequent Visitor
3 years ago
Solved

Distinctcount on two filter values

Hi, I wonder if someone could help me with this issue. I have the folowing table: Enterprise_Nbr LOB (Line_of_business) 1 A 2 B 3 B 1 B 4 C 5 B 2 B 1 C   I ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi YBavré 

    please try

    X =
COUNTROWS (
    FILTER (
        VALUES ( ENHANCED_CKI_CUSTOMER[Enterprise_Nbr] ),
        COUNTROWS (
            INTERSECT (
                CALCULATETABLE ( VALUES ( ENHANCED_CKI_PRODUCTS[LOB] ) ),
                { "A", "B" }
            )
        ) = 2
    )
)
speedramps's avatar
speedramps
Super User
3 years ago

Try this ...

 

Has A and B =
Var tempA =
CALCULATE(
    ISEMPTY('Table'),
    'Table'[LOB (Line_of_business)] = "A"
)

Var tempB =
CALCULATE(
    ISEMPTY('Table'),
    'Table'[LOB (Line_of_business)] = "B"
)

RETURN
INT(NOT(tempA || tempB) )
 
 
Your answer  =
CALCULATE(
    DISTINCTCOUNT('Table'[Enterprise_Nbr]),
    FILTER('Table',[Has A and B] =1))
 

Thanks for reaching out for help.

I put in a lot of effort to help you, now please quickly help me by giving kudos.

Remember we are unpaid volunteers and here to coach you with Power BI and DAX skills and techniques, not do the users job for them. So please click the thumbs up and accept as solution button. 

 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you ! 

 

Incidentally, next time please DON'T copy & paste your DAX that does not work and expect us to fathom what you want to do. That is crazy. 😀

 

Please just give a simple non technical functional decscription of what you want, then let us suggest the DAX. Thank you. 😀😀😀

 

YBavré's avatar
YBavré
Frequent Visitor
3 years ago

Hi speedramps , thank you for trying helping me with this issue. However, it does not seem to be functionning when I aplpy it on my dataset.

I'm totally new on this forum, so I do not know yet all the rules, but I keep your tips in mind.