Show values of a column based on current filter selection

[Pulkit]

Hi All,

Is there any way we can apply a filter on the values that are being shown in a column in a table?

For example, I have a customer column and I am calculating there rolling 12 months sales and I am also calculating there previous 12 rolling month sales. So when I put these 2 measures in a table with customer column it also starts showing my customer from beyond rolling 12 months. I have tried putting conditions where rolling 12 months is blank but showing wrong results. Any advice?

Currently, there is only a single table for all this so no data model is there. 

[Anonymous]

Hi @Pulkit,

Do you means use filter/slicer to interaction with clause column/table to make them 'dynamic'? If this is a case, current power bi does not support this, they are stored on different data levels and not able to use the child level to effect its parent.

Notice: the data level of power bi.

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> virtual table of data view(measure, visual, filter, slicer)

Regards,

Xiaoxin Sheng

[amitchandak]

@Pulkit , Not very clear

Can you share sample data and sample output in a table format? Or a sample pbix after removing sensitive data.

If your measure

Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],max('Date'[Date],-12,MONTH))

Rolling 12 till last 12 month = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],max(dateadd('Date'[Date],-12,month)),-12,MONTH))

Measure =if(isblank([Rolling 12]),blank(),[Rolling 12 till last 12 month])