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?