Cumulative percentage measure to include some and exclude some filters & returning some constants
Hi dear all , Lemme make you understand my model. I have a measure Cumulative%oftotal as follows. When the measure applied on against the chassis list, I get the values computed as shown. The total accounts to 100% even with two shown filters and one hidden filter. That is fine for me. The date provides the quantity to alter. The Tray size provides the chassis list to change. Also, a third hidden filter will change the quantity. So, with all this filters I needed the total of cumulative total to 100%. That happens perfectly. Now. I have another scenario, where there are filters as shown in. Yes. when I try to add the same measure to the table in the bottom . It returns the following. But, I donot need this to happen. I expect the same value shown in the image 2 get populated in it. I need a measure that pulls the value from the image 2. or modification of the same measure so as to use in the image 4. This is my first requirement. Second, In image3, It shows me at selected date period and date and selected time bucket in graph, it has 16 chassis count and the same is listed in the below table. As per the image 2, there is a cumulative % listed. I need three individual measures listing 1. count of chassis matching the selected 16 in this case list with cumulative % <=0.8 2. count of chassis matching the selected 16 in this case list with cumulative % >0.8 & cumulative <=0.95 3. count of chassis matching the selected 16 in this case list with cumulative % >0.95 A seperate measure to replace in certain tables with the cumulative percentage based on the above three conditions to Fast, Medium & Rare respectively I will be so thankful. Thanks
