Forum Discussion

anithaMallam's avatar
anithaMallam
Helper III
5 years ago

need help

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

 

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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's avatar
      anithaMallam
      Helper III
      5 years ago

      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's avatar
        anithaMallam
        Helper III
        5 years ago

        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.