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.
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.