Forum Discussion
Fining a Percentage
Hi, Anonymous
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Table1, Table2, Table3, Table4:
You may create four measure as below.
Visual Control 1 = IF( SELECTEDVALUE(Table1[Pass 25])>=25*0.5, 1,0 ) Visual Control 2 = IF( SELECTEDVALUE(Table2[Pass 50])>=50*0.54, 1,0 ) Visual Control 3 = IF( SELECTEDVALUE(Table3[Pass 75])>=75*0.64, 1,0 ) Visual Control 4 = IF( SELECTEDVALUE(Table4[Pass 100])>=100*0.58, 1,0 )Finally you need to put the measure in the corresponding visual level filter to get the filtered result.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi MFelix ,
The 25, 50, 75 and 100 are the number of swipes a customer can buy for the year. The 801 is the sum of passes in the 25 swipe passes bought for the year. The 403 is the sum of passes in the 25 swipe passes but filtered down to customers who didin't use over half of thier passes in the year.
25 Swipe Pass
| Customer ID | Number of Passes left |
| 1234 | 25 |
| 1235 | 20 |
| 1236 | 19 |
| 1237 | 15 |
| 1258 | 13 |
| Total | 92 |
Total amount of 25 swipe passes bought 200
92/200 = 46%
Sorry for the question once again and how do you now the number of passes you have with 25?
Is it based on the number of ID's multiplied by 25?
Can you share the data but with also the information about the rest of the passes because you show how many have swipes left but you must have lines with 0 correct?
DO you have any column that identifies the passes?
You should do something similar to this:
Percentage = SUM(Table[Number of Passes Left]) / calculate(SUM(Table[Number of passes bought); all(Table))