Tables and Filtering

[alex_smith]

Hello,

I'm trying to create noumerous charts that depend only on NON Blank values, is there any way to achieve that with DAX? To filter the main table before making the chart. My dataset has 5 columns

Code (id - key) (no blanks)

eShop (YES, NO or blank)

Sales (Number or blank)

Category1 (1,2,3 or blank)

Category2 (1,2,3 or blank)

One of the charts will be how many % have eShop and how many don't. So, I want to first take the original table, filter out the rows that have blank in the eShop column and then create the chart. The same idea is for all the other charts that I want to create. Any ideas?

[amitchandak]

@alex_smith , One is to use a visual level filter and remove blank

second a measure like

calculate(

divide(calculate(Count(Table[Code]), filter(Table, [eShop] ="Yes")), Count(Table[Code])) , filter(Table,not(isblank([eShop))) )