Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

we didnt get the expected output, all values are blank.

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi Anonymous ,

 

It had to convert it without data, please share some sample data and expect result.

Or you can try this:

Measure =
DIVIDE(
    SUMX( FILTER( ALL( 'Table' ), 'Table'[AUDITOR] <> [Auditor Filter] ), [NC] ),
    SUMX( FILTER( ALL( 'Table' ), 'Table'[AUDITOR] <> [Auditor Filter] ),  [APPEAR] )
)

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.