How to count rows of a measure in a table visual

[ErikHswe]

Hello,

I have a visual table containing 5 columns where 4 of those are measures.

Here is what they look:

Result this month = sum('q_view_pbi_invoice'[InvoiceAmountCUR])

Result last month = CALCULATE('q_view_pbi_invoice'[Utfall månad period invoice]; PREVIOUSMONTH('q_view_pbi_calendar'[CalendarDate]) )

Difference = q_view_pbi_invoice[Utfall månad period invoice] - q_view_pbi_invoice[Utfall fg månad period invoice]

Is difference positiv or negative = IF([diff kr invoice] <= 0; 0;1) 

Now, I want to count the last measure and display in a KPI how many results are negative and how many are positive for the current period (determined in a slicer visual). But I have tried a thousand things and nothing seems to work. Any advice would be appreciated.

[v-sihou-msft · Accepted solution]

@ErikHswe

To use apply calculation based on the result of measure, you have to summarize the measure into column group on data feild you put on row level in Table visual. Then you can create a measure like below:

Count Of Postive =
COUNTROWS (
    FILTER (
        SUMMARIZE (
            Table,
            Table[Row_Entry],
            "Is difference positiv or negative", [Is difference positiv or negative]
        ),
        [Is difference positiv or negative] = 1
    )
)

Regards,