Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have a measure in which I have positive and negative values which is achieved after perfroming a difference in 2 already existing measures. I want to add them separately and then take the percentage accordingly.
Please refer to the sample below:
TIA
Solved! Go to Solution.
Hi @singh_gagan30 ,
You can try this measure
Share % =
var negativesum = IF ([Measure 4] < 0 ,CALCULATE(SUMX(FILTER(ALL('Table'),[Measure 4]<0),[Measure 4])))
var Positivesum = IF ([Measure 4] > 0 ,CALCULATE(SUMX(FILTER(ALL('Table'),[Measure 4]>0),[Measure 4])))
RETURN
If ([Measure 4] > 0 , DIVIDE([Measure 4],Positivesum), DIVIDE([Measure 4],negativesum))
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Hi @singh_gagan30 ,
You can try this measure
Share % =
var negativesum = IF ([Measure 4] < 0 ,CALCULATE(SUMX(FILTER(ALL('Table'),[Measure 4]<0),[Measure 4])))
var Positivesum = IF ([Measure 4] > 0 ,CALCULATE(SUMX(FILTER(ALL('Table'),[Measure 4]>0),[Measure 4])))
RETURN
If ([Measure 4] > 0 , DIVIDE([Measure 4],Positivesum), DIVIDE([Measure 4],negativesum))
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
@singh_gagan30 , formula for share %. Can you share sample data and sample output in table format?
Hi @singh_gagan30 ,
Can you please specify, how you achieve this percentage value in "% share" column?
Your comments column doesn't make sense.
Write a proper example with values you are using to calculate the percentage.
Thanks,
Pragati
I added all the negative values and a denominator and numerator is row wise. for negative values i divided the negative row values to the dnominator and similary process for the positive values.
User | Count |
---|---|
124 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |