Filter table with dynamic condition

DAX DAX Calculations
1

Hi,

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.

image
image1862×1252 289 KB

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.

https://drive.google.com/file/d/1Zh_AcV-Etdry2oCUShyCarQYr2iOwi2V/view?usp=sharing

Thanks in advance…

Thanks,
Ritesh

2

@rit372002,

Sure – just apply the following filter condition to your visual in the filter panel and click apply.

image
image1058×405 47.7 KB

Then you can click on the three dots in the filtered visual, choose export data and send the data to CSV, where it can be imported into Excel.

Snag_1a9a8b92
Snag_1a9a8b92458×655 43.6 KB

I hope this is helpful.

  • Brian
1 Like
3

@BrianJ

thanks Brian! It works. I think when I tried it, it spin for a while so I thought it won’t work that way. It took a while but it worked.

thanks a lot!
Ritesh

4

@rit372002,

Great – glad to hear that worked for you. It did spin for a little while, and I think I noticed in your file that you had applied it at the page level, rather than at the visual level, the former of which is more resource intensive when you have multiple visuals on the page.

  • Brian