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-->
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-->