Forum Discussion

thales123's avatar
thales123
Frequent Visitor
8 years ago
Solved

Filter Measure with its Aggregated Value by Year

Hi Guys,   I've searched around and haven't found a solution for my need.   I have a sales database and I need to declare "Key Customer" to certain special customers in which have purchased more ...
thales123's avatar
thales123
Frequent Visitor
8 years ago

Not really, what we would like to have in the report is a filter where I could see only the results from the Key Customer. The main issue is that We would like to have a lot of data to analyse through this filter, what is impossible if we use summarize, and since I can not filter a sum of a measure (like a minimum value of total) I'm not able to do it.

 

Let's say I want to know, for Key Customers only how much they have bought from a specific category of product, or a specific item.

 

I'm almost doing this outside of Power BI via Excel, I will need some rework, but it will work. In Power BI there are some limitations for this specific need I have.

 

Thanks anyway for your support.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    I don't think that will be possible.  The only way to create a slicr for key customer is to create a seperate table or in the data table itself, have a sperate column identifying the Type of Customer.  Even if you can create that spare column in your data table, the problem would be that a slicer selection will not recopute that spare column.  Calculated column formulas only update when the model is refreshed (not when a slicer selection is made).