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

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Forum statistics

Threads
1,089,164
Messages
5,406,552
Members
403,095
Latest member
cyclingdad

This Week's Hot Topics

Top