Forum Discussion

mcomsto's avatar
mcomsto
Helper I
6 years ago
Solved

Counting rows based on difference between two filtered measures

Hi,   I have been struggling with this issue for some time.  I am trying to count the rows in a table visualization based on the difference between to calculated measures.  I have attached a pbix f...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    mcomsto here are the measure to count

     

    Q1 Above Zero = COUNTX ( VALUES ( Sheet1[Customer] ), IF ( [Comp Q1 Form Score Diff] > 0, 1 ) )

Q1 Equals Zero = COUNTX ( VALUES ( Sheet1[Customer] ), IF ( [Comp Q1 Form Score Diff] = 0, 1 ) )

Q1 Less Zero = COUNTX ( VALUES ( Sheet1[Customer] ), IF ( [Comp Q1 Form Score Diff] < 0, 1 ) )

     

    Would appreciate Kudos 🙂 if my solution helped. 

parry2k's avatar
parry2k
Super User
6 years ago

mcomsto here are the measure to count

 

Q1 Above Zero = COUNTX ( VALUES ( Sheet1[Customer] ), IF ( [Comp Q1 Form Score Diff] > 0, 1 ) )

Q1 Equals Zero = COUNTX ( VALUES ( Sheet1[Customer] ), IF ( [Comp Q1 Form Score Diff] = 0, 1 ) )

Q1 Less Zero = COUNTX ( VALUES ( Sheet1[Customer] ), IF ( [Comp Q1 Form Score Diff] < 0, 1 ) )

 

Would appreciate Kudos 🙂 if my solution helped.