Forum Discussion

Dshami's avatar
Dshami
Frequent Visitor
3 years ago
Solved

Showing count against count for duplicate values

I have a table with two columns SellerID and ClassID both having duplicates. Both are type Text. As shown in figure 1 each distinct SellerID has count of ClassID mapped.  I need to output other way ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi Dshami 

     

    You can first create a new table from the original table with below DAX. This is because the field on the x-axis should be a column. 

    New Table = SUMMARIZE('Table','Table'[SellerID],"Count_of_CLSID",COUNT('Table'[ClassID]))

    Then select "Count_of_CLSID" column from the new table into the column chart as x-axis. And select "SellerID" from the new table into the chart as y-axis and select "Count" aggregation for it. 

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

Dshami's avatar
Dshami
Frequent Visitor
3 years ago

Thanks a lot!