Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the challenge, I have a field called "TIPOMEDICION" that has two values "official" and "backup", I am using the dimension called "PUNTOSIMEC".
It turns out that I have data from the official pointsimec and backup, but sometimes I only have data from the official and not from the backup or vice versa, the challenge is that when there is data in the official pointsimec I add the data, but if there is data that adds me the data of the Puntosimec backup.
For this example I have two points loaded 40-4-81 & 40-82 but I do not have data from the official pointsimec of 40-4-82 but I need to add the data of the backup to complement.
I hope you have made me understand.
Current expression
SUM(If([TIPOMEDICION] ='OFFICIAL' AND [KWHR]>0,[KWHR]/1000))
Try this one in the expression
if(SUM({<[TIPOMEDICION] ={'OFFICIAL' }>}[KWHR])>0,
SUM({<[TIPOMEDICION] ={'OFFICIAL' }>}[KWHR])/1000,
SUM({<[TIPOMEDICION] ={'BACKUP' }>}[KWHR])/1000)
Hi,
I am not sure if I understand entierly, but you want to add data from the official and if there is backup data you also want to add this?
Best,
Ali A
Try this one in the expression
if(SUM({<[TIPOMEDICION] ={'OFFICIAL' }>}[KWHR])>0,
SUM({<[TIPOMEDICION] ={'OFFICIAL' }>}[KWHR])/1000,
SUM({<[TIPOMEDICION] ={'BACKUP' }>}[KWHR])/1000)
You can also try this
RangeSum(
Sum({<PUNTOSIMEC = {"=SUM({<[TIPOMEDICION] ={'OFFICIAL' }>}[KWHR])>0"}, [TIPOMEDICION] ={'OFFICIAL'}>} [KWHR]/1000),
Sum({<PUNTOSIMEC = {"=SUM({<[TIPOMEDICION] ={'OFFICIAL' }>}[KWHR])=0"}, [TIPOMEDICION] ={'BACKUP'}>} [KWHR]/1000))
Thanks Sibin , it works.