Forum Discussion

JdBernate's avatar
JdBernate
Frequent Visitor
8 years ago
Solved

Context problem (i guess)

Hi guys   im trying to count the products that represent the 80% percent of sales. I need my measure works outside of the report table as a kpi. In the next image you can understand better the situ...
Need Help
  • JdBernate's avatar
    JdBernate
    8 years ago

    Hi v-chuncz-msft

     

    Thank you for your help. The problem was in the filter, the content is ok, i changed the measure for avoid the values equal to zero.

     

    Number of Top 80% products =
    CALCULATE (
        DISTINCTCOUNT ( ListadoArticulos[Descripcion Articulo] );
        FILTER (
            ALLSELECTED(ListadoArticulos[Descripcion Articulo]  );
            AND([**bleep** totalArti] < [80%sales],[**bleep** totalArti] >0),
        )
    )

     

    Again, thank you for your time.

     

    regards

     

    Juan Diego

JdBernate's avatar
JdBernate
Frequent Visitor
8 years ago

Hi v-chuncz-msft

 

Thank you for your help. The problem was in the filter, the content is ok, i changed the measure for avoid the values equal to zero.

 

Number of Top 80% products =
CALCULATE (
    DISTINCTCOUNT ( ListadoArticulos[Descripcion Articulo] );
    FILTER (
        ALLSELECTED(ListadoArticulos[Descripcion Articulo]  );
        AND([**bleep** totalArti] < [80%sales],[**bleep** totalArti] >0),
    )
)

 

Again, thank you for your time.

 

regards

 

Juan Diego