Forum Discussion

Connell's avatar
Connell
Regular Visitor
4 years ago
Solved

Measure for One Table Being Used for All Items

Hi, So I have a structure that looks like DataSet1 A 10 B 12 connected via first column, DataSet 2 A A-1 25 A A-2 65 B B-1 20 B B-2 15 And once again DataS...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Connell 

    Ok. Would you please try

    Global =
    IF (
    NOT ISEMPTY ( 'DataSet3' ),
    SUMX ( 'DataSet3', IF ( 'DataSet3'[Column3] = "global", 1, 0 ) )
    )

Connell's avatar
Connell
Regular Visitor
4 years ago

Thanks amitchandak,
I want to actually indicate 0 for the items that are just in DataSet3. If I remove the 0, then they will be blank, along with other items not in DataSet3, so I won't be able to distinguish them. So if I do show items with no data, that doesn't solve what I am trying to do. I hope that adds some clarity.

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

Connell 

What we need to do is push the filter to restrict 0 only for dataset3

 

Not Global =
VAR notglobal = CALCULATE(
COUNT('DataSet3'[Column3]) +0,
Return calculate( notglobal, filter('DataSet3','DataSet3'[Col1] = max('DataSet2'[variable2])))

  • Connell's avatar
    Connell
    Regular Visitor
    4 years ago

    I tried to make the adjustments and it was unsuccessful, everything is still showing 0. Perhaps because of the relationship it just picks up the calculation regardless?