Forum Discussion

SniperPro's avatar
SniperPro
Frequent Visitor
3 years ago
Solved

Join two disconnected table with measure

Hello On PowerBI, I am connecting with live connection to an as tabular model, I cannot use power query. I .can only create a report level measure: I have an Opportunity Table and an Event Table th...
@Dax help
@need help
@powerbi
  • MohammadLoran25's avatar
    MohammadLoran25
    3 years ago

    Hi SniperPro ,

    Create the measure below and put it into your visuals and set it to 1:

    RelationFlag =
SUMX (
    FILTER (
        CROSSJOIN ( OpportunityTable, EventTable ),
        EventTable[Opportunity_ID] = OpportunityTable[Opportunity_ID]
    ),
    1
)

     

    If this answer solves your problem, give it a thumbs up and mark it as an accepted solution so the others would find what they need easier.

    Regards,
    Loran

MohammadLoran25's avatar
MohammadLoran25
Icon for Solution Sage rankSolution Sage
3 years ago

Hi SniperPro ,

Create the measure below and put it into your visuals and set it to 1:

RelationFlag =
SUMX (
    FILTER (
        CROSSJOIN ( OpportunityTable, EventTable ),
        EventTable[Opportunity_ID] = OpportunityTable[Opportunity_ID]
    ),
    1
)

 

If this answer solves your problem, give it a thumbs up and mark it as an accepted solution so the others would find what they need easier.

Regards,
Loran