Forum Discussion
DAX Formula
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.
| Status | Value | DAX % |
| Opening ARR | 3531.32 | 100.0% |
| Churn | 200.00 | 5.7% |
| Downsell | 100.00 | 2.8% |
| Gross Retention | 3531.32 | 100.0% |
| Upsell | 256.82 | 7.3% |
| Net Retention | 3788.14 | 107.3% |
| New | 50.00 | 1.4% |
| Acquisitions | 10.00 | 0.3% |
| Closing ARR | 3788.14 | 107.3% |
The Opening ARR is devided by the Opening ARR which gives me the 100% then each status is devided into the Opening ARR to give me their % but all needs to be in one column.
Hi Ritaf1983 ,thanks for the quick reply, I'll add further.
Hi coetseem ,
The Table data is shown below:
Please follow these steps:
1. Use the following DAX expression to create a measure
value = SUM('Table'[Sum of ARR Value])2.Use the following DAX expression to create a measure
Measure =
VAR _a = MAXX(FILTER(ALL('Table'),'Table'[Reporting Status] = "Opening ARR"),[Sum of ARR Value])
RETURN DIVIDE([value],_a)3.Final output
Good day,
This does not work on my dataset.
I have over 80 000 clients and each one have a line with a Opening ARR, Churn etc so in the data set you will need to add a few clients each with an Opening ARR, Churn etc. Below is the output that i get when i applied the measure.
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.