Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
How can I calculate the percentage of a row value out of the total of the column of said value, with the total of the column being absolute and not changing relative to filters or fields? The normal SUM function calculates the total, but changes depending on the date or any other filter.
Hi,
A measure like this should help
=SUM(Data[Amount])/CALCULATE(SUM(Data[Amount]),ALL(Data))
Not exactly, but I found the problem, my domain was not continuous and so any sum measure would just add it per category and not progressively.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
87 | |
73 | |
54 | |
43 | |
37 |
User | Count |
---|---|
98 | |
64 | |
54 | |
48 | |
45 |