Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
I'm having some issues with something im trying to create.
I need to identify the German (DE) ID's where the price doesn't match the Swedish (SE) price for the same ID. The Norweigan (NO) are irrelevant.
I've been sitting with alot of different dax formulas but I can't seem to find a solution.
Help would be greatly appreciated!
Solved! Go to Solution.
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.
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.
Regards
You just want to identify these and not do any further visualization or calculation?
Try this,
Create a slicer with Country (Orgin) and select SE AND DE
Create a table visual where you put ID on values and define a new measure that will identify the ID's like this:
DifferentPrice =
IF(AVERAGE(Data[Price])<>MAX('Data'[Price]);1)
All done!
Br,
Magnus
The price row will sometimes deal with mix of string and integer values so I cant get the datatype right and therefore im having issues using your solution. I trying different workarounds now.
Br, Johannes
I'm not sure this needs Power BI. Can't you just do this manually? it's a very small dataset
I'm not able to use the accual dataset here. The one im working with contains over 50 000 rows. Sorry that I have to use a stand-in!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |