Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Urgent_ Issue when filter data with value created by Measure

Dear all,

May I get your advice on my below issue?

Context: I have a table with value"Inventory" is created by Measure. I want to filter top 5 products in High status by Inventory level.

Issue: The result is the only product in high status from top 5 products by Inventory level. It may be only 1 or 2 or 3, not 5.

Please find details below, appreciate your advice. 

Thanks so much!

 

https://drive.google.com/file/d/1ILuB72wObZlOl3Z9wW2nBJpzLIqL8yMG/view?usp=sharing

 

 

 

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    "created by measures"  is not enough information.  You need to provide the computation for the measures as they can impact the result of the TOPN.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ，

    Whether your problem has been resolved? If no, could you please share some source data in your tables and the formula of measures(such as Inventory, DSC) which applied in table visual in order to make troubleshooting? By the way, the field "Status" is measure? If yes, could you please also provide the related formula. If it involve any calculation, please provide the backend logic. It is better if you can provide a sample pbix file(exclude sensitive data). Thank you.

    Best Regards

    Rena