Hi Kasper,
the [RecordCount]-measure contains the count of records for each column. Hence if you select a whole table, the measure does not reflect the number of rows of that table which is probably a bit misleading.
I came up with this calc which should produce "more correct" results
NewRecordCount = SUMX(ADDCOLUMNS(GROUPBY(DatabaseSize, DatabaseSize[Table]), "RecordCountTable", CALCULATE(MAX(DatabaseSize[RecordCount]))), [RecordCountTable])
-gerhard
Hi Kasper,
the [RecordCount]-measure contains the count of records for each column. Hence if you select a whole table, the measure does not reflect the number of rows of that table which is probably a bit misleading.
I came up with this calc which should produce "more correct" results
NewRecordCount = SUMX(ADDCOLUMNS(GROUPBY(DatabaseSize, DatabaseSize[Table]), "RecordCountTable", CALCULATE(MAX(DatabaseSize[RecordCount]))), [RecordCountTable])
-gerhard