Values depends upon the relative slicer

[Sujith12345]

Hi,

I have a measure,

CARs = calculate( count( table name= 0, column name)),

And for replacing the blank values, I use the measure,

visits with 0 CAR = if ( CARs = blank(), 0, CARs) 

And used another measure also,

CARs = calculate( count( table name= 0, column name))+0

And if I select the particular time period, it shows the remaining years as 0.

Can anyone please help to get the particular time period alone.

 

[v-xiaotang]

Hi @Sujith12345 

Thanks for reaching out to us.

For the date table bellow, do you mean if you select Last 1 month, then you need the measure to return the period between 2021/10/1 - 2021/10/31?

In this scenario, this result is depended by the max date 2021/11/3 in Table.

Date

2021/9/1

2021/10/2

2021/11/3

If yes, you can get the expected result directly by the selection bellow,

If not, could you describe your expected result based on the examples? Thanks.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Sujith12345]

@v-xiaotang , thanks for your response.

If I select the date range last 1month, I have to get the value for 2021 alone, but here it shows like 2017,2018,2019,2020 values as 0, I don't want that to be visible while I select ' last 1 month ' in relative slicer

[v-xiaotang]

Hi @Sujith12345 

Is the value in slicer same as that in the table visual? If they are not from the same table, you need to use visual level filter.

Not sure what's your data, could you provide some sample data or a sample file? so that we can write specified solution which meets your need. Thanks.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.