Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

visualization need

Hi, for my project i have celebrities and their instagram followers' count. In the report when i select a celebrity's name it must be show me that celebrity's followers count. But in my situation, th...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi Anonymous ,

     

    According to your description, when you successfully import the data source. You can create a dimension table of celebrity as a filter, and then create a measure to count the number of different celebrities. I did a test, the reference is as follows:

     

    M_count =
CALCULATE (
    COUNTROWS ( 'Table' ),
    ALLEXCEPT ( 'Table', 'Table'[celebrity_id] )
)

     


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi Anonymous ,

 

According to your description, when you successfully import the data source. You can create a dimension table of celebrity as a filter, and then create a measure to count the number of different celebrities. I did a test, the reference is as follows:

 

M_count =
CALCULATE (
    COUNTROWS ( 'Table' ),
    ALLEXCEPT ( 'Table', 'Table'[celebrity_id] )
)

 


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


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