Forum Discussion

Trisulara88's avatar
Trisulara88
Frequent Visitor
2 years ago

Filtering out all items based on one value in a vertical table

Hello all, this is my first post and I hope I can express myself correctly 🙂 I have a table containing different sales KPI's on a product level with the following columns: Product | Date | KPI | ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Trisulara88 ,

 

You can try to create measure like below, it shows the products where the weighted distribution KPI is > 10.

WeightedDistribution_GT_10 = 
CALCULATE(
    SUMX(
        FILTER(
            VALUES(Sales[Product]),
            CALCULATE(
                MAX(Sales[value]),
                Sales[KPI] = "weighted distribution"
            ) > 10
        ),
        1
    ),
    ALL(Sales[KPI])
)

 

If it's not what you want, please provide test data and screenshots of the desired results.

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly