Compare and count similarities 2 measures

MrJoosten

Board Regular
Joined
Nov 12, 2016
Messages
118
Hi Guys,

I cant get this done and some help would be awesome.

I've got 2 measures.
1st measure calculates count of ID's based on certain filters
2nd measure does the same


I want to know if there are same ID's in both measures and count the similarities.
I already tried to do something like:

var =


VAR 1st measure = measure1
VAR 2nd measure = measure2

RETURN
SUMX(
SUMMARIZE(
table
table[ID's];
"total"; measure1+measure2);
total>1)

But it isn't working yet.

Thank you for your time.


Kind regards,
Peter



<!--EndFragment-->
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Watch MrExcel Video

Forum statistics

Threads
1,090,142
Messages
5,412,696
Members
403,442
Latest member
keowinvip1

This Week's Hot Topics

Top