Forum Discussion

CatherineWang's avatar
CatherineWang
Frequent Visitor
3 years ago

How to count specific measure in matrix

Hi,everyone!

I have a matrix as below, I would like to calculate the percentage of the total Dim quantity that is RFT% greater than 98%. In this matrix ,there is 5 Dims' RFT%>98%, so is 5/12=42%. And RFT% is a measure, how to write the DAX,thanks!!!

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    CatherineWang , Try a measure like

     

    divide(countx(filter(Values(Table[Dim]) , [RFT%] >.98 ), [Dim]) , countrows(Values(Table[Dim]) ) )

    • CatherineWang's avatar
      CatherineWang
      Frequent Visitor
      3 years ago

      Sorry, [RFT%] is a measure, maybe couldn't be used in "filter".