Forum Discussion
Helper IValues depends upon the relative slicer
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.
3 Replies
v-xiaotangCommunity Support
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.