Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello All,
We have value column in the source which contains values for multiple attributes as values as "NA" meaning not applicable.
Below is the sample report:
We need to create a measure which will show the summation of values in such a way that
1) If we calculate region wise then SUM all values & show the summation
2) If we calculate Year wise then SUM all values & show the summation
3) if we calculate Region & year wise and there is no NA then show summation
4) if we calculate Region & year wise and there is all NA values then show NA
Kindly suggest how to create such measure.
Thanks,
PBI V2
Solved! Go to Solution.
You will not be able to SUM values with an explicit NA value since you can't combine numeric and text data. You need to replace NA with 0 or some default value you define. Then the measure is as easy as SUM(Table[ColumnName]).
Proud to be a Super User!
You will not be able to SUM values with an explicit NA value since you can't combine numeric and text data. You need to replace NA with 0 or some default value you define. Then the measure is as easy as SUM(Table[ColumnName]).
Proud to be a Super User!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
92 | |
86 | |
76 | |
66 |
User | Count |
---|---|
146 | |
111 | |
109 | |
103 | |
96 |