Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help with % measure per category

Hi I need some help in creating a measure that shows % of disputes over total number of calls for each category.  So for XP = 8531/17k, CIP = 2922/10.8k Could someone assist, thanks very much!   ...
Need Help
  • negi007's avatar
    negi007
    5 years ago

    Anonymous in this case, you can create a measure like below

     

    Measure =
    var c_bus = COUNTAX('Table','Table'[Business])
    var m_bus = CALCULATE(COUNTX('Table','Table'[Status]),'Table'[Status]="Dispute")
    return
    m_bus/c_bus
     
    below is the output that you are looking for. 
     

    thanks

negi007's avatar
negi007
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous in this case, you can create a measure like below

 

Measure =
var c_bus = COUNTAX('Table','Table'[Business])
var m_bus = CALCULATE(COUNTX('Table','Table'[Status]),'Table'[Status]="Dispute")
return
m_bus/c_bus
 
below is the output that you are looking for. 
 

thanks

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks so much!!!!