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