Dax help

[Kumarcy]

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

[Greg_Deckler · Accepted solution]

@Kumarcy  - So maybe:

Total Column = SUMX(ALL('Table2'),[Amount])

[Kumarcy]

@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,

[Greg_Deckler]

@Kumarcy - That should just be:

Total % = [Amount] / [Total]

[Kumarcy]

@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?

[camargos88]

Hi @Kumarcy ,

Try this measure:

Measure = CALCULATE(SUM('Table'[Amount]), ALL('Table'[Type]))