Forum Discussion

aalstatt7287's avatar
aalstatt7287
New Member
2 years ago
Solved

Percents with small subgroups

This may be a dumb question but I am not sure how to do this. I am not great with the DAX functions.

 

I have a pie chart that shows the proportion of different Control Types in a group of control samples. I have a card that displays the percentage of control samples vs Original Samples sent.

 

When I click on one of the pie peices, the card changes to "Infinity". I would like for each pie peice to show the percentage of that specific control type vs total original samples.

 

I am pretty sure this is a change that needs to be made in my measure for "Percent of Total" but I am not sure what to use for this.

It currently reads: 

Percent of Total = COUNT('Control Samples'[Control Type])/COUNT('Original Samples'[Sample Number])
 
"Control Samples" file contains all the types of control samples ie duplicate, umpire, CRM, etc. "Original Samples" contains only the original samples. I need precent of Original Samples for each control type.
 
Thanks so much!
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    aalstatt7287 are these tables related? In the meantime try this:

     

    Percent of Total = COUNT('Control Samples'[Control Type])/CALCULATE(COUNT('Original Samples'[Sample Number]), ALL () )

     

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    aalstatt7287 are these tables related? In the meantime try this:

     

    Percent of Total = COUNT('Control Samples'[Control Type])/CALCULATE(COUNT('Original Samples'[Sample Number]), ALL () )

     

    • aalstatt7287's avatar
      aalstatt7287
      New Member
      2 years ago

      Yes, they are realted. Both contain samples, but I split the data into 2 files instead of leaving it as one as that seemed to help me with the other visualizations I was working on, since the total number of original samples doesnt need to be seen, only the percent of each control type. I am sure there are ways to do it with the file all together in one, but I have just been stumbling my way through it.

       

      Your DAX function did exactly what I needed! Thank you so much for your help, you are much appreciated! 🙂