Dax measure filter condition to refer or filter data inside another table

[sivarajan21]

Hi,

I have below dax measure that sums units in DataProfile Unpivotted (2) table and filter condition from points table.This works well:

Generation units =
CALCULATE (
SUMX ( 'DataProfile Unpivotted (2)', 'DataProfile Unpivotted (2)'[Units] ),
FILTER ( 'Points (3)', 'Points (3)'[Utility] = "Solar PV" )
)

I have a utility table:

Utility

Solar PV

Solar

Generation

Electricity

Gas

Water

I am confused on how to refer these utility table data in filter conditions of above Dax measure.

For example, currently the  measure sums units based on filter "Solar PV" . But I would expect this measure to include/refer all data inside the utility table to filter the units in DataProfile Unpivotted (2) table.

Can you please help me out?

Please let me know if you need further info!

Thanks in advance!

@Ahmedx @Ashish_Mathur @grantsamborn @amitchandak @Greg_Deckler 

[Ashish_Mathur]

Hi,

It will depend upon the relationships.  Share the download link of the PBI file.