Forum Discussion
Enter Formula Into Matrix
Hi, I have the following matrix and I would like to fill in the empty fields with a formula that references the other values in the matrix. The BDG comes from 1 table and the STD and Actual ...
No the table that the STD calculates from doesn not have values at all for F. F comes from the BDG table and from that I need to derive hte desired value.
I managed to replace the empty cells with a generic value like 0 or no value. But I am having issues getting my calculated value into those fields
I tried creating 4 seperate measures. I added them to seperate cards and I get my desired values for each. I realize I dont need to seperate them but it helps keep track as I am new to PowerBi.
M1= CALCULATE(SUM(Bdg[BDG]),'Bdg'[Cost]="F")
M2= CALCULATE(SUM(Bdg[BDG]),'Bdg'[Cost]="E")
M3= CALCULATE(SUM(DB[STD]),DB[Group1]="E")
M4 = M1/M2*M3
M4 = M1/M2*M3
But when I add M4 into my matrix, it comes up empty. I am guessing it because it doesnt know how to relate the calculated value to the row? How would I go about linking that are assigning my final value to F?
HI achen ,
Can you please share some sample data for test? It will be help for test to coding formula.
Notice: do mask on sensitive data or make some fake data with same data structure for test.
Regards,
Xiaoxin Sheng