Count number of items with growth

[moses07_ferns]

I have done the Month Over Month Calculation, Year Over Year Calculation and I would like to have a card visual that counts the number of items where there is an increase from this table visual.

[lbendlin]

Do a SUMMARIZE over the items in your table visual, then ADDCOLUMNS to materialize the "increase"  measure (whatever that is).  Then return the COUNTROWS of the filtered virtual table.

[Anonymous · Accepted solution]

Hi, @moses07_ferns 

Based on your description, I have created some measures to achieve the effect you are looking for. Following picture shows the effect of the display.

Measure:

MoM% =

VAR _prevValue =

    SELECTEDVALUE ( 'Table'[Prev Month] )

VAR _curValue =

    SELECTEDVALUE ( 'Table'[Cur Month] )

VAR _PreDivCur =

    CALCULATE ( DIVIDE ( _prevValue, _curValue ) )

VAR _CurDivPre =

    CALCULATE ( DIVIDE ( _curValue, _prevValue ) )

RETURN

    IF ( _curValue > _prevValue, _CurDivPre, - ( _PreDivCur ) )



DistinctCountSales =

Counts =

CALCULATE (

    DISTINCTCOUNT ( 'Table'[Cur Month] ),

    FILTER ( 'Table', [MoM%] > 0 )

)

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum