Forum Discussion

zenton's avatar
zenton
Helper 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
Helper II
4 years ago

No it is a static value from a database no calcultion

tamerj1's avatar
tamerj1
Community Champion
4 years ago

zenton 

So how is this visual related to the count measure?

  • zenton's avatar
    zenton
    Helper 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