Hi Please see below data. Basically i want to calculate 3 things. 1st is APV, APS and Measure or Calculated Column:
I have Year Slicer on page: Year Slicer selected as All
APV = if category is "LEN" and year is Current (Current year 2020) then Count LEN
APS = Category is LEN and Count of LEN 2021 and 2022
if we select Year from slicer 2021 then:
APV = LEN count of Year 2021 and then APS will be LEN count of Year 2022 and so on
and last measure or calculated column: the LEN of Current year will become SPN for Next year so i want to count growth and this will also involve year slicer selection.
Sorry if i am still not clear, let me know if you need more detail. Thanks in advance for your help
| Category | Year |
| Len | 2020 |
| Len | 2020 |
| Len | 2021 |
| Len | 2020 |
| Len | 2021 |
| Len | 2021 |
| Len | 2021 |
| Len | 2020 |
| Len | 2022 |
| Len | 2022 |
| Len | 2022 |
| Len | 2022 |
| SPN | 2020 |
| SPN | 2021 |
| SPN | 2022 |
