Hello everyone,
Would somebody please advise how I will do a filter action using measure values only?
So I have 2 calculated fields that compute the last 7 days record closed and created. one based on date started and one based on date closed. Then I put these 2 measure names in my Rows and nothing else so below is my actual worksheet.
I then put this in my dashboard along with other worksheets. Now my issue is I was trying to use this as a filter to my details table, is that possible as I can't make it to work right now. I was hoping that if I click on that 2 created prev week, my detail table will show me only that 2. Right now, it's not doing anything as if there is no connection between that 2 records and my detail table.
I wish I could send a test WB but i can't replicate my data for sample upload so if you have further questions, would you let me know please and I'll just answer them. It will help me big time as this is the first time filter is not working for me. Must be the kind of data I am filtering. I am used to filtering from a pie or bar or map, but this one is from automatic marks type. I can't figure out what I am doing wrong. Let me know please if you have any idea.
thanks so much - jhun
posted a file.