Can I filter a table based on something which is already in table? for e.g.:
Here I have core customers (core customers are defined as all the customers which lead up to 80% of the total sales). Last customer which constitutes about 80% of the overall sales is 350799 with sales amount $25,521.
Now I want to see only these customers until 350799 (basically list of core customers), nothing below that because users want to export this list to excel.
I have tried different filters on the filter pan but it doesn’t work. I thought of calculated column as well but that won’t be dynamic. Attached is the pbix.
Thanks in advance…