Forum Discussion
hama21
Helper I
Helper IHelp with a measure using fields from 1 table but using this measure in multiple fields table visual
Hi, I have a measurethat is as follows:
MEASURE = CALCULATE(COUNT(TABLE A[ITEM NUMBER]), TABLE A[ITEM NUMBER] = 15)+0
(I'm using +0 to display rows when the result is blank())
If I create a table with these specifics fields(item, item number and measure), I can use the measure and find the correct result:
| TABLE A | TABLE A | |
| ITEM | ITEM NUMBER | MEASURE |
| A | 15 | 2 |
This is the expected result I want, using two fiels from anothers tables:
| TABLE A | TABLE B | TABLE C | TABLE A | |
| ITEM | DESC A | DESC B | ITEM NUMBER | MEASURE |
| A | DESC 1A | DESC 1B | 15 | 2 |
This is the table that I'm receiving when using all fields that I want
| TABLE A | TABLE B | TABLE C | TABLE A | |
| ITEM | DESC A | DESC B | ITEM NUMBER | MEASURE |
| A | DESC 1B | 15 | 0 | |
| A | DESC 2B | 15 | 0 | |
| A | DESC 1A | DESC 1B | 15 | 2 |
| A | DESC 1A | DESC 2B | 15 | 0 |
| A | DESC 1B | DESC 1B | 15 | 0 |
| A | DESC 1B | DESC 2B | 15 | 0 |
Could you guys please help me to get the expected result. I don't know if the problem is in my measure or not.
Thank you
