unable to populate measure into different tables

[Anonymous]

Hi Expert

i have five tables that have different name but have the same column names in each table, there is not relationship between the five tables. 

I am trying to populated the same mesure formula with different measure name into each of the five tables, however this works fine for two tables when i come to apply the measure formula to the 3rd table is does not recongise the table.

[parry2k]

@Anonymous not full clear why it will not work on 3rd table. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

hi parry2k...

here is the dax formula i am trying to populate into table manufacturing with a different measure name.

PMSReportability_country = SWITCH(TRUE(),
    'PMS_COMPLAINT_COUNTRY'[REPORT_REQUIRED]="Y","Yes",
    'PMS_COMPLAINT_COUNTRY'[REPORT_REQUIRED]="N","No",
    "No Decision")

https://www.dropbox.com/s/vy94k43lke21swl/Sample.pbix?dl=0

[parry2k · Accepted solution]

@Anonymous are you adding column or measure? This seeme like column which you cannot do because there is no relationship of manufacturing table with other tables.

[Anonymous]

I can create the measure in country table the switch formula I just posted and no relationship

[Anonymous]

Would like to add a measue

[parry2k]

@Anonymous then your DAX formula is not correct, coz measure must use some aggregation. Also measures are global across the report, it doesn't need to be in specific table.

[Anonymous]

Ok parrky2k. If I use columns calculated. Then can i use a switch formula based on selected values I.e. what filters I select.?

[Anonymous]

hi Parry2k. Ill upload a file. with sample data give me an hour or so.