Showing filters on multi-row card

[BIGDADE5000]

I am struggling to find a way to display the proper values on a multi-card row.  I want the multi-row card to display a measure.  The issue is that I can get it to work when I filter the data but don't know how to get it to display the values when not filtered. 

I have two tables, 'STD Hours - SAP' and 'Worked Hours' with a relationship on [Line Detail] in each table.

Slicer for [Line Detail]:

Here is the measure:

DLE =

VAR SelectedLine = ALLSELECTED('Worked Hours'[Line Detail])

VAR SelectedLine2 = ALLSELECTED('STD Hours - SAP'[Line Detail])

VAR HoursWorked = CALCULATE(SUM('Worked Hours'[Hours]),'Worked Hours'[Line Detail] in SelectedLine)

VAR EarnedHours = CALCULATE(SUM('STD Hours - SAP'[HMOD Earned]),'STD Hours - SAP'[Line Detail] in SelectedLine2)

RETURN

    DIVIDE(EarnedHours,HoursWorked)

Here is the value of the DLE measure when no [Line Detail] is selected (which is actually correct for ALL [Line Details] as it is summing ALL 'STD Hours - SAP'[HMOD Earned] and 'Worked Hours'[Hours], but not BY [Line Detail]).  I want this total by each [Line Detail]:

When I select a line from [Line Detail], the results are showing properly (it should be 63.6%, not 32.2% as displayed above):

I want the DLE to display for all rows ([Line Detail]) in my multi-row card when not filtered.  DLE should equal the sum of 'STD Hours - SAP'[HMOD Earned] divided by the sum of 'Worked Hours'[Worked Hours] for each 'STD Hours - SAP'[Line Detail].  I hope I explained what I was trying to do properly!  I am sure it is something "simple" with my filtering but I can not figure it out.  Any help provided is greatly appreciated!  Thank you.

[Anonymous]

Hi @BIGDADE5000 ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[BIGDADE5000]

Xiaoxin,
Thank you for the reply.  Can I send the .pbix to you directly?  I am a little hesitant to post it on here.

[Anonymous]

HI @BIGDADE5000,

You can upload to network driver and share the link here.  (notice: please not attach sensitive data in shared files)

If these records include sensitive data and you can't simple remove them, you can create some dummy data with similar data table structures and paste in your post with table formula and expected result.

Regards,

Xiaoxn Sheng