Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
Hi @VandanaPulluri ,
You could try the following DAX:
DownTrend =
VAR a =
COUNTA ( 'DIm_Product'[Product_ID] )
VAR b =
FILTER (
ALLSELECTED ( 'Dim_Sales'[Year_IND] ),
CALCULATE ( '_Measures'[p-value] <= 0.05 && 'Dim_Sales'[TAU 1] < 0 )
)
RETURN
CALCULATE ( SWITCH ( TRUE (), ISBLANK ( a ), BLANK (), a ), b ) + 0
Hi @VandanaPulluri ,
You could try the following DAX:
DownTrend =
VAR a =
COUNTA ( 'DIm_Product'[Product_ID] )
VAR b =
FILTER (
ALLSELECTED ( 'Dim_Sales'[Year_IND] ),
CALCULATE ( '_Measures'[p-value] <= 0.05 && 'Dim_Sales'[TAU 1] < 0 )
)
RETURN
CALCULATE ( SWITCH ( TRUE (), ISBLANK ( a ), BLANK (), a ), b ) + 0
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |