Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
H Power Users,
I need help with a DAX calculation. I have 2 table and have relationship. I have Type column in table 1 and Amount column in Table 2.
Below is the example data.
Input | |
Type | Amount |
A | 100 |
B | 200 |
C | 300 |
D | 400 |
Total | 1000 |
Output | ||
Type | Amount | Total |
A | 100 | 1000 |
B | 200 | 1000 |
C | 300 | 1000 |
\D | 400 | 1000 |
Total | 1000 | 1000 |
Total is the measure of Sum(Amount)
Thanks
Solved! Go to Solution.
@Kumarcy - So maybe:
Total Column = SUMX(ALL('Table2'),[Amount])
@Kumarcy - So maybe:
Total Column = SUMX(ALL('Table2'),[Amount])
@Greg_Deckler Thank you. It worked really well. I would like calculate % Total based on the measure created.
%Total= Amount/ Total
Out put:
Output | |||
Type | Amount | Total | % Total |
A | 100 | 1000 | 10% |
B | 200 | 1000 | 20% |
C | 300 | 1000 | 30% |
\D | 400 | 1000 | 40% |
Total | 1000 | 1000 | 100 % |
Thanks,
@Kumarcy - That should just be:
Total % = [Amount] / [Total]
@Greg_Deckler Thanks for reply. I have a blank value in type and has amount to that. I would like to include the amount in total measure but should not show in the visual and i have a visual filter like id not equal to 1. How can i acheive this?
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |