Forum Discussion

Pillsbury33's avatar
Pillsbury33
Icon for Helper I rankHelper I
6 years ago
Solved

Dividing two fields and a filter

Hello everyone,   I’m hoping someone can help with my question. I am trying to divide two calculations in two separate tables with a visual filter. The logic I am looking for is effectively is to c...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Pillsbury33 ,

     

    Firstly, you need to create a relationship between two tables in the model tab if you don't have it.

    Then refer to the following DAX:

    Measure =
CALCULATE (
    SUM ( 'Table'[Incident] ) / SUM ( 'Table (2)'[employee] ),
    ALLEXCEPT ( 'Table', 'Table'[Site] )
)

    Here is the result.

    Here is my test file for your reference.

     

v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Pillsbury33 ,

 

Firstly, you need to create a relationship between two tables in the model tab if you don't have it.

Then refer to the following DAX:

Measure =
CALCULATE (
    SUM ( 'Table'[Incident] ) / SUM ( 'Table (2)'[employee] ),
    ALLEXCEPT ( 'Table', 'Table'[Site] )
)

Here is the result.

Here is my test file for your reference.