need help

[anithaMallam]

Hi All,

          I have two tables Payment terms and payment terms master tables which has a common key which ARP Payment Terms Key to make realtionships. 

Now i need to see how many Sales AR Transaction Payment Terms have mapped to the AR Payment Terms Master data by organization 

• To report the number of unmapped payment terms by organization

could some one please help me out how to write the calculation logic to pull the data it will be a great help.

Regards

Anitha

[amitchandak]

@anithaMallam , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

To know the data on one side which is not present , we can use +0 in a measure or this option

[anithaMallam]

Hi Amit,

               Thanks alot for responding.i dont have any sample data as i am importing these tables from sql to power bi for the requirement 

i need to see how many Sales AR Transaction Payment Terms have mapped to the AR Payment Terms Master data by organization 

• To report the number of unmapped payment terms by organization.

Regards

Anitha

[anithaMallam]

Hi Team,

              Can you please share the calculation logic for calculated column to get 

• To report the number of unmapped payment terms by organization.

Regards

Anitha.

[PaulDBrown]

@anithaMallam 

Please read this thread to help us help you:

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523