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.
Hi there, first post and new user of powerBI. Screenshots are of pivot tables in excel I am recreating in PowerBI.
I need help transposing my current formula for calculating the % of row total (working here in table 1):
% = SUM(ttData[USD Media Spend]) / CALCULATE(SUM(ttData[USD Media Spend]),ALLSELECTED(ttData[G2 Media Type]))
I now need to calculate the column total as seen here:
Here is my current formula:
% = DIVIDE (
SUM(ttData[USD Media Spend]),
CALCULATE (
SUM(ttData[USD Media Spend]),
ALLSELECTED(ttData[Year])))
Of which the outcome is this:
Its obviously not quite right! Any help is appreciated. Very new to DAX. Thank you.
Solved! Go to Solution.
Hi
Instead of allselected for the year i think you need media type
Mike
Hi
Instead of allselected for the year i think you need media type
Mike
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |