Forum Discussion

VulcanPromance's avatar
VulcanPromance
Helper II
7 years ago
Solved

Calculate issue

Ok.. So I have this project that involves 3 tables. Employees, Licenses, Cost Employees contain ID Name Company Country 1 Eric Test1 Inc Norway 2 Peter Test2 Corp Sweden 3 J...
Need Help
  • AnthonyTilley's avatar
    AnthonyTilley
    7 years ago

    i have created a PBIX file that may be what you want 

     

    PBIX File

     

    you dont not want to use a distinct count of the id becuase the id in itself is not unique. just use a count

     

     

    this file has a sheet that alows you to do what you asked click on one of the countrys and the table to the right will show the brakedown of the number of licences by type with a count and a sum of the price based on the quantity type 

     

AnthonyTilley's avatar
AnthonyTilley
Solution Sage
7 years ago

i have created a PBIX file that may be what you want 

 

PBIX File

 

you dont not want to use a distinct count of the id becuase the id in itself is not unique. just use a count

 

 

this file has a sheet that alows you to do what you asked click on one of the countrys and the table to the right will show the brakedown of the number of licences by type with a count and a sum of the price based on the quantity type