Complex Bands Analisys

[carlosch1807]

First... sorry about my english... I try to explain better as possible...

I try to make this table in power pivot

Forecast Band / Skus Quantity / Sales / Forecast
0-49.99% / 17 / 500 / 1,500
50%-79.99% / 12 / 1,000/ 1,800
80%-100% / 5 / 8,000/ 9,000


I make a Disconected table, but i cant related this whith the data

I work with 4 Sheets.... F_Sales / F_Forecast / Disconected Ranges / Dim_Articles

Please HELP!!!!

Bes Regards from El Salvador, Centroamerica

Carlos Chavez

 

[Matt Allington]

I wrote a blog about this a couple of weeks ago. Does this help? Banding in DAX - Excelerator BI

 

[carlosch1807]

Thanks Matt... really appreciate your help... Is exactly what I needed.... I had to pay ... 2 day ago... for this metric..

SalesByProduct:=IF (
OR(ISFILTERED( D_Rangos[Rango] ) , ISFILTERED( Temporal_Familia[Familia] )),
CALCULATE (
[Portafolio Articulos Neto],
FILTER (
VALUES ( Dim_Articulo[ARTICULO] ),
COUNTROWS (
FILTER (
D_Rangos,
[Alcance Unidades] >= D_Rangos[RangoInicial]
&& [Alcance Unidades] < D_Rangos[RangoFinal]
)
) > 0
)
),
[Alcance Unidades]
)