-
1. Re: calculation filter
Andrew Kim Sep 11, 2017 3:39 PM (in response to Imran Azam)Hi,
Take a look at the workbook I've attached.
I wasn't entirely sure what you wanted to count so I created two measures.
Count: Counts the Errors and Track ID's by Descriptions.
Count (Fixed): Counts the overall number of Errors and Track ID's.
Let me know if this is what you were looking for.
-
Count.twbx 22.2 KB
-
-
2. Re: calculation filter
Imran Azam Sep 11, 2017 9:45 PM (in response to Andrew Kim)this is more or less correct how did you do this?
-
3. Re: calculation filter
Imran Azam Sep 12, 2017 2:41 AM (in response to Imran Azam)any other suggestions guys?
-
4. Re: calculation filter
T G Sep 12, 2017 2:50 AM (in response to Imran Azam)Hello Imran,
Please update your formula as
IIF([Count Selector]='Error',COUNT([Error]),COUNT([Track Id])).
TG
-
5. Re: calculation filter
Imran Azam Sep 12, 2017 3:34 AM (in response to T G)hi TG thank you, what do you mean by count selector?
-
6. Re: calculation filter
T G Sep 12, 2017 3:41 AM (in response to Imran Azam)You have parameter which has two options Error and Track ID.
-
7. Re: calculation filter
Imran Azam Sep 12, 2017 4:18 AM (in response to T G)is that in the original sheet I sent? I think that's in Andrews reply, how do I create that? that is the problem I am having as I cant open the sheet here at work
-
-
9. Re: calculation filter
Imran Azam Sep 12, 2017 4:31 AM (in response to T G)thank you TG, I read this but I don't understand how I can create one based on the fields I have, any advice would be much appreciated thank you again
-
10. Re: calculation filter
T G Sep 12, 2017 4:52 AM (in response to Imran Azam)Please refer the attached updated workbook.
-
Book1 (6).twbx 11.0 KB
-
-
11. Re: calculation filter
Imran Azam Sep 12, 2017 5:06 AM (in response to T G)Tg thanks you but I cant open this worksheet on work pc , can you send screen shot?
-
-
13. Re: calculation filter
Imran Azam Sep 12, 2017 5:32 AM (in response to T G)OK thank you, I have an issue the counts are not changing when I change the count selector
-
14. Re: calculation filter
T G Sep 12, 2017 5:36 AM (in response to Imran Azam)Make sure you have same name of your dimension and in parameter.