Forum Discussion

ljx0648's avatar
ljx0648
Icon for Helper III rankHelper III
2 years ago
Solved

Count distinct profile for distinct ID

Hi guys,   I am a table of data similar to the one below:   ID Assign to Web Profile Profile Attribute 1 Profile Attribute 2 More Attribute columns 1 A A1 Y N … 1 A A2 N Y ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi ljx0648 ,

    Ahmedx's solution is right , because you have multiple web Attributes, and you can use ALLEXCEPT to remove all other attribute column filters, and subsequently just filter the different rows of the assign to columns

    Below is my table:

    The following DAX might work for you:

    Column_assign = 
   CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[Assign to]))

    The final output is shown in the following figure:

    At this point in time, it would be difficult for you to compute this result with the rest of the variables in the property columns

    Best Regards,

    Xianda Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ljx0648 ,

Ahmedx's solution is right , because you have multiple web Attributes, and you can use ALLEXCEPT to remove all other attribute column filters, and subsequently just filter the different rows of the assign to columns

Below is my table:

The following DAX might work for you:

Column_assign = 
   CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[Assign to]))

The final output is shown in the following figure:

At this point in time, it would be difficult for you to compute this result with the rest of the variables in the property columns

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.