Forum Discussion

AllisonB's avatar
AllisonB
Frequent Visitor
1 year ago

Percentage calculation using measure and table column

I need to create a percentage of the unique callers that have called more than 5 times. I have created (with help from this forum - thanks) tables and measures to to group the count of calling numbers 

              

 

 

These produced this visulization 

 

What I need to do now is get a sum of the unique callers that called 5 or more times as a percentage of the total unique callers. I've tried to create a measure to calculate the sum of the unique callers that called 5 or more times so I could then divide that by the unique callers measue but I haven't been able to find a way to do it. I have create a visual that gives the total number of those calls, 182, so I know that the percentage should come out at 0.99%.

 

I will also need to calculate the total number of calls made by those who's calling number appeared more than 5 times, so this but this doesn't work 

CALCULATE(SUM('AL BT data'[Calling No]),COUNT('AL BT data'[Calling No])>=5) 
I've also tried filtering on the unique callers band table but that didnt work either
CALCULATE(SUM('AL BT data'[Calling No]),'Unique Callers Band Table'[Times Called]="5")
When I have that total I will need to then get a percentage of that against the total number of calls made
 
Any help would be gratefully received, thanks in advance
 
Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi AllisonB ,

    Just from your screenshot I don't fully know what data is in your table.
    There are a lot of column names that do not appear in your DAX code.
    Please provide the relevant example data and the specific .pbix file if you can.

     

     

    Best Regards

    Yilong Zhou

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