Forum Discussion

sidnir's avatar
sidnir
Regular Visitor
2 years ago
Solved

Multiplication based on a rate table

Hi all, I'm slightly new to this so I'll try to explain the problem as best as possible.   My main table contains call data records for devices. Each row is a single data session. device ID, tota...
Need Help
  • aduguid's avatar
    aduguid
    2 years ago

    Try this measure 

    Total Device Rate1 per Month = 
VAR DistinctDevices = DISTINCTCOUNT('Call Data Table'[device ID])
VAR DeviceCountry = SELECTEDVALUE('Device Reference Table'[country])
VAR Rate1 = LOOKUPVALUE('Rate Card Table'[rate1], 'Rate Card Table'[country], DeviceCountry)

RETURN 
DistinctDevices * Rate1