Forum Discussion
Check for different values in the same row
The Answer is Here.
Measure = VAR _count = CALCULATE ( DISTINCTCOUNT ( 'Table (7)'[Price] ), ALLEXCEPT ( 'Table (7)', 'Table (7)'[Material ID] ) ) RETURN IF ( _count = 1, "FALSE", "TRUE" )
For Measure, you can use this
Check for different purchase prices =
IF (
SELECTEDVALUE ( 'Table'[IDPurorg] ) = SELECTEDVALUE ( 'Table'[1Purorg] )
&& SELECTEDVALUE ( 'Table'[IDPurorg] ) = SELECTEDVALUE ( 'Table'[2Purorg] )
&& SELECTEDVALUE ( 'Table'[IDPurorg] ) = SELECTEDVALUE ( 'Table'[3Purorg] )
&& SELECTEDVALUE ( 'Table'[1Purorg] ) = SELECTEDVALUE ( 'Table'[2Purorg] )
&& SELECTEDVALUE ( 'Table'[1Purorg] ) = SELECTEDVALUE ( 'Table'[3Purorg] )
&& SELECTEDVALUE ( 'Table'[2Purorg] ) = SELECTEDVALUE ( 'Table'[3Purorg] ),
"FALSE",
"TRUE"
)
OutPut : -
Hi Vairag99, thank you for your support. I think there is a misunderstanding due to showing my table as a pivot. I apologize. For my measure I will need to use 3 fields from the same table ("PurchasePrice").
1) dimPurchasePrice[MaterialID]
2)dimPurchasePrice[PurOrg]
3)dimPurchasePrice[Price]
All the needed purchase org info are retrieved from only 1 field, namely dimPurchasePrice[PurOrg]. I.e. the field dimPurchasePrice[PurOrg] can have the following values. PurOrg 1, PurOrg2, PurOrg3 or PurOrg4 (like below)
Do you also have an idea to get it work with the layout below?
Many thanks in advance
Br
Harry
| Material ID | PurOrg | Price |
| A | PurOrg1 | 2 |
| A | PurOrg2 | 2 |
| A | PurOrg3 | 2 |
| A | PurOrg4 | 2 |
| B | PurOrg1 | 2 |
| B | PurOrg2 | 3 |
| B | PurOrg3 | 5 |
| B | PurOrg4 | 2 |
I hope this layout is better and understandable
The Answer is Here.
Measure = VAR _count = CALCULATE ( DISTINCTCOUNT ( 'Table (7)'[Price] ), ALLEXCEPT ( 'Table (7)', 'Table (7)'[Material ID] ) ) RETURN IF ( _count = 1, "FALSE", "TRUE" )Anonymous , it is working as expected. Thank you very much. Your support is much appreciated