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.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Pillsbury33 , Not sure I got. You need to create a common Site table/dimension and join with both tables.

Then you can create % = divide(Sum(Table1[Incident]),Sum(Table2[Employee]))