Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
moses07_ferns
Regular Visitor

Count number of items with growth

Screenshot 2024-02-22 140030.png

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.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

 

vyaningymsft_0-1708933521166.png

 

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

 

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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.

 

vyaningymsft_0-1708933521166.png

 

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

 

 

lbendlin
Super User
Super User

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.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.