Hi Mynda:
I am diving into Power Pivot DAX, and need help with a measure.
I need to divide 2 rows, isfrn by isfrd by label or Net Income by Revenue.
I am stuck. I tried = SUMX (Table_Measure(DIVIDE( Table_Measure[isfrn], Table_Measure[isfrd] ) - no go.
Can you help or give me some direction?
Regards,
Robb
Hard to say without seeing how your data is structured and the PivotTable layout. Have you tried using just =DIVIDE(Table_Measure[isfrn], Table_Measure[isfrd])
Mynda
I thought for sure I attached.
I'll try again to attach, please let me know if you.
Looks like it uploaded but I can't view or confirm using "View Existing"
Regards
Robb
Hi Robb,
Thanks for the file.
Your data is in the wrong layout. You need to unpivot the values in the Table_Measure table. You shouldn't have separate columns for each year. You should have one column for the year and one column for the values.
The Table_Dimensions is redundant in this calculation because you already have the Line Item names in the fact table that you need. See file attached.
Mynda
