Forum Discussion

zenton's avatar
zenton
Icon for Helper II rankHelper II
4 years ago
Solved

Count from summarised row count

Hi, I have a measure to Countrows of summarized data. Results in the table below. I need a measure to show count of the rows that equal 18. So the result should be 4 as per table below Measure 3 ...
COUNT
DAX
Measures
SUMMARIZE
  • tamerj1's avatar
    tamerj1
    4 years ago

    zenton 
    It is sometimes confusing when don't have the actual data. I will go back to your Measure 3 and start from there

    Relative price =
SUMX ( VALUES ( Labware[Calendar Date] ), IF ( [Measure 3] = 18, 1, 0 ) )
zenton's avatar
zenton
Icon for Helper II rankHelper II
4 years ago

tamerj1 

 

 

 

Yes the Count will be displayed on Card or Text box

Thanks Rodney

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

zenton 
What is value? is it measure 3?

  • zenton's avatar
    zenton
    Icon for Helper II rankHelper II
    4 years ago

    No it is a static value from a database no calcultion

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      4 years ago

      zenton 

      So how is this visual related to the count measure?

      • zenton's avatar
        zenton
        Icon for Helper II rankHelper II
        4 years ago

        tamerj1  I created the Count measure to try to get count of all records that have incomplete records. But the Count Measure I wrote would only give totals for all records which equaled to 90.

        I need a Measure to Count all incomplete records. In the Matrix above, there is 4 complete and 2 incomplete. So I need a measure to show the count of 4