Forum Discussion
Solved
DAX formula needed to extrapolate missing values
Dataset: Table: Table2: What I have so far: Sales % = CALCULATE(DIVIDE(SUM([Sales]),CALCULATE(SUM([Sales]),ALLSELECTED('Table')))) Profit = SUM([Profit Amount]) ...
Hi Mooma
I am not sure if I am addressing your question properly, as you already have extrapolated profits in the visualization, but does the following measure answer your question?
Hi @Mooma,
The relationship between the ID dimension table and two fact tables with numbers
are as shown below, as both fact tables contained the numbers, I thought it is easier to separate out the ID dimension table for clarification purposes and create relationships with the two fact tables.
I attach the pbix file for this task:
https://1drv.ms/u/s!AlqFfzVTqicpnW54pZuvMrAu9qKv?e=ANmLbD
That works. Thank you