topic Count number of items with growth in DAX Commands and Tips

Count number of items with growth

moses07_ferns — Thu, 22 Feb 2024 11:03:08 GMT

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.

Re: Count number of items with growth

lbendlin — Thu, 22 Feb 2024 22:57:24 GMT

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.

Re: Count number of items with growth

Anonymous — Mon, 26 Feb 2024 07:46:02 GMT

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