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.
I need to add 0.5 to a measure within a matrix table, however when I do that it keeps adding a year to the table with 0.5 in that column. Is there a way to add 0.5 to the dax measure without it creating a default value for other years and adding them to the table?
For example, the table has 2021 data and 2022 data 2021 has the data which needs 0.5 added to it. However, by adding 0.5 to the dax measure it adds the years 2019, 2020 and 2023 with 0.5 only which isnt accurate.
The Dax measure used is:
Solved! Go to Solution.
FYI that you don't need the CALCULATE with that expression, but here is how to adapt it.
Weighted Average Profit Margin =
VAR wapf =
DIVIDE ( [IEA*PROFIT MARGIN], SUM ( 'Detail'[IEA] ) )
RETURN
IF ( ISBLANK ( wapf ), BLANK (), wapf + 0.5 )
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
FYI that you don't need the CALCULATE with that expression, but here is how to adapt it.
Weighted Average Profit Margin =
VAR wapf =
DIVIDE ( [IEA*PROFIT MARGIN], SUM ( 'Detail'[IEA] ) )
RETURN
IF ( ISBLANK ( wapf ), BLANK (), wapf + 0.5 )
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |