Forum Discussion
Solved
DAX Formula
Good day,
I am looking for a dax formula that can caclulate a % over each status.
Meaning Churn / Opening ARR = -2.8 but i want to do this for all statuse below in one coloum.
Each status is devided over the Opening ARR.
| Reporting Status | Sum of ARR £m | % of Opening ARR |
| Opening ARR | 111.38 | 100.0% |
| Churn | - 3.17 | -2.8% |
| Downsell | - 3.99 | -3.6% |
| Gross Retention | 104.22 | 93.6% |
| Upsell | 17.25 | 15.5% |
| Net Retention | 121.46 | 109.1% |
| New | 3.62 | 3.3% |
| Acquisitions | - | 0.0% |
| Closing ARR | 125.08 | 112.3% |
Hi coetseem ,
Is this column the sum of all your clients?
Use the following DAX expression to create measures
value = SUM('Table'[ARR Value])Measure = VAR _a = SUMXX(FILTER(ALL('Table'),'Table'[Reporting Status] = "Opening ARR"),[ARR Value]) RETURN DIVIDE([value],_a)If you simply want to see the values for a single user, put the user field in the slicer.
7 Replies
Hi coetseem
How does your data look?
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...Account No CF_CU_NAME Sum of ARR Value DatePeriod Period Entity Region Reporting Status Reporting Status Detailed Tier1 3531.32153 P6 - Jun-23 P6 UKR UK Opening ARR Opening ARR Tier1 3531.32153 P6 - Jun-23 P6 UKR UK Gross Retention Gross Retention Tier1 256.81846 P6 - Jun-23 P6 UKR UK Upsell - Upsell Revenue Stream Tier1 3788.13999 P6 - Jun-23 P6 UKR UK Net Retention Net Retention Tier1 0 P6 - Jun-23 P6 UKR UK Acquisitions - Acquisitions Revenue Stream Tier1 3788.13999 P6 - Jun-23 P6 UKR UK Closing ARR Closing ARR Tier10 542.47853 P6 - Jun-23 P6 UKR UK Opening ARR Opening ARR Tier10 542.47853 P6 - Jun-23 P6 UKR UK Gross Retention Gross Retention Tier10 71.97887 P6 - Jun-23 P6 UKR UK Upsell - Upsell Revenue Stream Account No CF_CU_NAME Sum of ARR Value DatePeriod Period Entity Region Reporting Status Tier1 3531.32153 P6 - Jun-23 P6 UKR UK Opening ARR Tier1 3531.32153 P6 - Jun-23 P6 UKR UK Gross Retention Tier1 256.81846 P6 - Jun-23 P6 UKR UK Upsell Tier1 3788.13999 P6 - Jun-23 P6 UKR UK Net Retention Tier1 10 P6 - Jun-23 P6 UKR UK Acquisitions Tier1 3788.13999 P6 - Jun-23 P6 UKR UK Closing ARR Tier10 200 P6 - Jun-23 P6 UKR UK Churn Tier10 100 P6 - Jun-23 P6 UKR UK Downsell Tier10 50 P6 - Jun-23 P6 UKR UK New
