how to show constant value based on date selection in slicer

[sreddy47652]

Hi Team, I want to show constant value based slicer selection on user. I have below measure which is counting the backlogs so  i want to show this backlog value in all rows.

Count_Backlog =
var startdate =MIN('Financial'[Create_Date.Created_Date])

RETURN
CALCULATE( DISTINCTCOUNTNOBLANK('Financial'[CR_ID])
,'Financial'[Create_Date.Created_Date]<=startdate &&
NOT('Financial'[Sub.FinalState] IN {"CPA", "PCR", "FCI", "PCO"})) -- This measure will return the values as 2315

So now i am trying to use below meausre to show constant value(2315) for  all rows but it was not giving as expected.

Count_Backlog_ConstantValue = CALCULATE([Count_Backlog], ALL('Financial'))

Can anyone help me how can i show  constant value for all the rows.

[v-xiaocliu-msft]

Hi @sreddy47652 ,

Sorry, I'm still unclear about the relationship between your needs (measure) and the your sample data. I hope you haven't oversimplified your problem and sample data structure.

Best Regards,

Wearsky

[v-xiaocliu-msft]

Hi @sreddy47652 ,

Sorry, the link still cannot be accessed anonymously.

Best Regards,

Wearsky

[sreddy47652]

@v-xiaocliu-msft  Please check now

https://drive.google.com/drive/folders/1RHpZiPvzAAj9bFzwmdnq6wLASMungsOc?usp=sharing

[v-xiaocliu-msft]

Hi @sreddy47652 ,

Thanks for sharing. But I can't access the link as I don't have access rights.

Best Rgards,

Wearsky

[sreddy47652]

Given access please check

[sreddy47652]

@v-xiaocliu-msft  have you checked the data, any findings please share.

[v-xiaocliu-msft]

Hi @sreddy47652 ,

Have a good day. I can't reproduce the problem.

Could you provide sample data and expected values?

Best Regars,

Wearsky

[Ritaf1983]

Hi @sreddy47652 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

[sreddy47652]

@Ritaf1983 @v-xiaocliu-msft  Please find the attached sample data for your refreance 

https://drive.google.com/drive/u/0/folders/1RHpZiPvzAAj9bFzwmdnq6wLASMungsOc