How do I count the result of a measure?

[Anonymous]

Hi everyone!

So I have created some measures to calculate the difference between some values in two different time stamps. Having the measure that calculates that difference,  I would also like to have a measure that counts all the possitive values outputed from that measure. I have tried some stuff out but with no luck. Below I show the measures I've used. Any help would be much appreciated. Let me know if you need any more information.

After Avg KPI Value = 
CALCULATE(
    AVERAGE('DVI KPI'[KPI value]);
    FILTER(
        'DVI KPI';
        [Snapshot ID] = MAX('Snapshot Date Info'[Snapshot ID])
    )
)

Before Avg KPI Value = 
CALCULATE(
    AVERAGE('DVI KPI'[KPI value]);
    FILTER(
        'DVI KPI';
        [Snapshot ID] = MIN('Snapshot Date Info'[Snapshot ID])
    )
)

// I want to count the output of this measure
PBDC Avg KPI Value = 
    var __Difference = [Before Avg KPI Value] - [After Avg KPI Value]
return
    DIVIDE(__Difference; [Before Avg KPI Value])

[Anonymous]

Hi @Mariusz @rajulshah 
I can share just those screenshots just so you can have an idea of the data I'm using.

[v-deddai1-msft]

Hi @Anonymous ,

Just a guess, in the same context for your [After Avg KPI Value]  and [Before Avg KPI Value]  MAX('Snapshot Date Info'[Snapshot ID]) = MIN('Snapshot Date Info'[Snapshot ID]).

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[rajulshah]

Hello @Anonymous,

You can create another measure:

Total KPI Value =
VAR SummarizedTable =
    SUMMARIZE (
        'Snapshot Date Info',
        'Snapshot Date Info'[Snapshot ID],
        "AvgKPIValue", [After Avg KPI Value]
    )
RETURN
    COUNTX ( FILTER ( SummarizedTable, [AvgKPIValue] > 0 ), [Snapshot ID] )

Hope this helps. Let me know if it doesn't.

[Anonymous]

Hi @rajulshah 

No luck unfortunately. Here's what I got. I made some changes to your formula, like the measure I want to count and the Table that has the actual KPI values I am using in the previous measures

[rajulshah]

Hello @Anonymous ,

Can you provide sample file?

[Anonymous]

Hi @rajulshah 

Im sorry I can't. The file contains a lot of sensitive information and I've been told I can't share it. 

[Mariusz]

Hi @Anonymous 

You will need to first define the grain, let's say your visual has Date and colour columns, your measure would be.

PBDC Avg KPI Value =   
SUMX(
    SUMMARIZE( 'DVI KPI', 'DVI KPI'[date], 'DVI KPI'[Colour] ),
    VAR __Difference = 
        [Before Avg KPI Value] - [After Avg KPI Value]
    RETURN 
        INT( 
            DIVIDE( __Difference; [Before Avg KPI Value] ) > 1
        )
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

Hi @Mariusz 
I tried the measure and it didn't quite work for now. Here's what I got

[Mariusz]

Hi @Anonymous 

Try using 

VALUES( 'DVI KPI'[Snapshot ID] )

instead of SUMMARIZE() 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

@Mariusz Do you mean like that?