Forum Discussion
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 ...
Hi @tamerj1
The measure4 gave me a result of 90
The MaxValue calculted to 1 not 18
I will give some more information.
Each date has multiple [LIMS Text ID]
Each LIMS Text ID has a max of 18 [Analyte Name]
Each [Analyte Name] has a [Value]
On some dates not all the [Analyte Name] have a result in [Value]
In the table provided the first 4 dates the [Analyte Name] contains all 18 [Value]
In the last 2 dates the [Analyte Name] contains only 9 [Value]
Thanks Rodney
zenton
Ok Then it is easier to hard code it
Measure 4 =
VAR MaxValue = 18
RETURN
SUMX (
SUMMARIZE (
Labware,
Labware[Analyte Name],
Labware[LIMS Text ID],
Labware[Calendar Date]
),
IF ( [Measure 3] = MaxValue, 1, 0 )
)
Hi tamerj1 That is exactly what I did but I get a result of 0
This is because Measure3 gives a result of 90. I only get a Count for each date if I use Measure3 in a Table with the date field