Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
63 | |
52 | |
47 |
User | Count |
---|---|
218 | |
86 | |
64 | |
63 | |
60 |