Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi guys, new in pbi, hence needed your help. How do i show a column sum throughout all rows such as the value in static r. Currently i hard coded it as a static value ( static r = 352493410) but as the data refresh's i want to show it change dynamically (since the total can change) while remaining as a static total through out the rows in the column.
Solved! Go to Solution.
then it's even simpler
Static r = CALCULATE([80% of revenue],ALLSELECTED(TableName))
you need to replace red syntax with whatever is relevant for you
Static r = CALCULATE(SUM(TableName[ColumnName]),ALLSELECTED(TableName))
Static r = CALCULATE(SUM(TableName[ColumnName]),ALLSELECTED(TableName))
this works but in my case i am using a measure (80% of revenue) hence any alternative ?
then it's even simpler
Static r = CALCULATE([80% of revenue],ALLSELECTED(TableName))
It worked. Thanks 🙂
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
109 | |
105 | |
73 | |
71 |