Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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.
Solved! Go to 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
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
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.
User | Count |
---|---|
12 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
14 | |
11 | |
7 |