Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
84 | |
83 | |
67 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |