Forum Discussion

Kristinfortner's avatar
Kristinfortner
Frequent Visitor
3 years ago

Compare filtered data to overall data

Is there a way to show the overall data and data filtered by customer in the chart format below? If not, how can this be done? We want to be able to see the customer data and filtered data on a doubl...
Need Help
edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
3 years ago

Yes, you just need to remove the customer filter to see all the data. So if the measure generating that data is [Customer Sentiment] then the following measure will break out of the filtered customer:

All Customers =
CALCULATE (
    [Customer Sentiment],
    REMOVEFILTERS ( Customers )
)

So no matter what is selected in the filter or slicer, that measure will ignore it and show all Customers. (Assuming your customers are in a table called Customers.)

If that isn't what you need, or want more help, we need more info. See below.

 

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.