using filter and divide in a meaure

[Shega]

Hello,

just an info, I am new to PBI from a DBA background and working on converting a report that is written on OBIEE. Here is one problem I couldn't solve:

fact_tbl.gl * 100/filter(fact_tbl.rc USING (fact_tbl.cust='X'))

fact_tbl.gl is float datatype

fact_tbl.rc is float datatype

fact_tbl.cust is char datatype

I used the PBI filter but the USING clause part is an issue that I couldn't come up with a good solution. When I tried as below, it is not giving me the correct result. 

Custx = divide(calculate(fact_tbl.gl]*100),calculate(fact_tbl[rc]),filter(fact_tbl, fact_tbl[cust] ="X"))

[mark_endicott]

@Shega - Did this work? Please could you mark it as the solution if yes, this helps other users find it. 

[mark_endicott]

@Shega - The DAX below should work for you, with the exception of having to change the table/column names:

VAR gl = SUMX(fact_tbl, fact_tbl[gl] * 100)

VAR rc = CALCULATE( SUM(fact_tbl[rc]), KEEPFILTERS( fact_tbl[cust] ="X"))

RETURN
DIVIDE( gl, rc, 0 )

If this works, please accept it as the solution.