Forum Discussion

kukszi's avatar
kukszi
Helper I
3 years ago

Using measure as a slicer

Hi there,   I'd like to create a measure for price ranges that I can use as a filter criteria in a slicer or to show the price distribution in a chart. The approach I try to do is the following: ...
Need Help
kukszi's avatar
kukszi
Helper I
3 years ago

Hi TaylorPBI21 ,

 

Thanks for your reply. Actually, I forgot to mention that the structure of my report is a bit tricky, that doesn't make it possible (or at least I don't know how to make it work). The main problem is that I have the sales volume and sales value in different tables, and measures calculate everything else (e.g the average price as well). If I understand correctly, to make your approach work, I would need to create a combined table. But I have already set up measures to summarize the data the way how the user wants to see (e.g different timeframes e.g last 1 month, last 3 months, YTD, etc; by city; store type; product size), which means that in this new table I'd need to re-create all those parameters as well, what I'd like to avoid. 

 

Is there any solution where I could use the approach I have started with the separate table?

  • TaylorPBI21's avatar
    TaylorPBI21
    Resolver I
    3 years ago

    Hi kukszi ,

     

    Could you sample data say 5 rows from each table and then the measure you are using to get the average? 😎

     

    Many Thanks,

     

    Taylor

  • TaylorPBI21's avatar
    TaylorPBI21
    Resolver I
    3 years ago

    Hi kukszi,

     

    What's the relationship between the 2 tables you're using?😊