Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Power BI / DAX

Hello, I am new to this community and I seek guidance and assistance to those who are experts in this particular field.

 

I have a table where I need to know how many ideal customers we have by these requirements:

X & Y Services(Services Column) - Should be both
TRUE(Boolean Column) - this will state that they really offer the Services(X &Y)
Description(Description Column) - Either of the 3 specific description

 

Roadblocks - when I filter the services and boolean column, the description column will be empty. Same goes with description column, services column will be empty.

 

In order to know how many Ideal customer, need to pass the requirements/criteria.

 

 

Please advise, thank you!

5 Replies

  • Wilson_'s avatar
    Wilson_
    Icon for Memorable Member rankMemorable Member
    3 years ago

    Hello NewUser_711,

     

    Any chance you can actually share your data, or at least some sample/mock data? 🙂

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Yeah, sure. At first, It failed when I upload. But here it is. 

      • Wilson_'s avatar
        Wilson_
        Icon for Memorable Member rankMemorable Member
        3 years ago

        This doesn't seem representative of your full dataset and I also cannot figure out how your issue arises, based on the snippet of data you're showing.