Hello,
I have a measure that returns the number of distinct visitors from a column for each zone (or all zones depending on the applied filter). The thing is, I have to apply a ratio to that value (before it is returned), depending on the zone. But as long as a measure cannot determine a unique value from a column, I have no idea how to use that ratio.
For example, I have 3 zones in wich I want to measure the number of distinct visitors for each while appliying the ratio depending on the zone ( 100 people * 1.2 for the first zone, 250 people * 1 in the second and 325 * 0.6 in the last) and then I want to make a sum of those numbers or something.
nb_devices =
var nb = CALCULATE(DISTINCTCOUNT(meraki_observation_zone[client_mac]))
// ratio = CALCULATE(DISTINCT(zone_ratio[ratio]);FILTER(zone_ratio; zone_ratio[zone]=meraki_observation_zone[zone]))
// nb2 = nb * ratio
return IF( ISNUMBER(nb) ; nb ; 0 )
Thanks in advance!
