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
aduguid's avatar
aduguid
Memorable Member
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
  • sidnir's avatar
    sidnir
    Regular Visitor
    2 years ago

    Awesome! Thank you for the quick response!

    This worked perfectly!

    Thank you so much!! ğŸ˜Š