Forum Discussion
Assistance needed
- 9 years ago
Hi tex628,
Based on my test, you should be able to use the formula below to create a calculate column in your table to identify the German (DE) ID's where the price doesn't match the Swedish (SE) price for the same ID .
Tag = VAR sePrice = CALCULATE ( FIRSTNONBLANK ( Table1[Price $], 1 ), FILTER ( ALL ( Table1 ), Table1[ID] = EARLIER ( Table1[ID] ) && Table1[Origin] = "SE" ) ) RETURN IF ( Table1[Origin] = "DE" && Table1[Price $] <> sePrice, 1, 0 )Then you can use the tag column as visual level filter or as Slicer to show the result on the report.
Here is the sample pbix file for your reference. :smileyhappy:
Regards
Hi tex628,
Based on my test, you should be able to use the formula below to create a calculate column in your table to identify the German (DE) ID's where the price doesn't match the Swedish (SE) price for the same ID .
Tag =
VAR sePrice =
CALCULATE (
FIRSTNONBLANK ( Table1[Price $], 1 ),
FILTER (
ALL ( Table1 ),
Table1[ID] = EARLIER ( Table1[ID] )
&& Table1[Origin] = "SE"
)
)
RETURN
IF ( Table1[Origin] = "DE" && Table1[Price $] <> sePrice, 1, 0 )
Then you can use the tag column as visual level filter or as Slicer to show the result on the report.
Here is the sample pbix file for your reference. :smileyhappy:
Regards