Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear Community,
Below is my table in the Page 1 of power BI sofware
SL | TP |
AD | 311628 |
AS | 137153 |
CB | -65774 |
TA | 117019 |
Tx | 152892 |
Total | 652918 |
I need 2 solutions
1) an additonal measure which calculates my Running %, see my output table below which i want to achieve(below i did manually in excel)
Required Output in % |
48% |
21% |
-10% |
18% |
23% |
100% |
2) Automated text which changes dynamically based on the value
"Ad constitute 48% of total pipeline value, followed by Tx 23%"
Let me know how to achieve this
Solved! Go to Solution.
I think the issue was with scenario where there is only 1 entry meeting the criteria, try this code
Measure = VAR _Summary = ADDCOLUMNS(VALUES('Table'[SL]),"Value",[TP_SUM],"%",[Running %]) VAR _Top2 = TOPN(2,_Summary,[%],DESC) VAR _FirstValue = MAXX(_Top2,[%]) VAR _FirstName = FILTER(_Top2,[%]=_FirstValue) VAR _SecondValue = MINX(_Top2,[%]) VAR _SecondName = FILTER(_Top2,[%]=_SecondValue) RETURN CONCATENATEX(_FirstName,[SL]) & " constitute " & FORMAT(_FirstValue, "Percent") & " of total pipeline value, followed by " & CONCATENATEX(_SecondName,[SL]) & " " & FORMAT(_SecondValue, "Percent")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |