Forum Discussion
Measure using slicer value in two different ways
- 1 year ago
Hi M_Ulloa
The issue with your Measure3 returning the same value across all rows stems from the use of SELECTEDVALUE, which doesn't behave as expected when used in a row-level evaluation within a table visual. Instead, you’ll want to leverage the current row context to dynamically reference the “Initiating Org” rather than relying solely on the slicer’s value.
Could you please modify your Measure 3 like this:
Measure3 = CALCULATE( [Count], FILTER( ALL(myTable), myTable[Initiating Org] = EARLIER(myTable[Initiating Org]) && myTable[Ending Org] = SELECTEDVALUE(myTable[Ending Org]) && myTable[Initiating Org] <> myTable[Ending Org] ))Alternatively, consider using a calculated column if you're looking to simplify row-level logic.
hello M_Ulloa
please check if this accomodate your need.
although i am not sure why you have G in your expected result screenshot if the screenshot showed B value in EndingOrg slicer.
also i am not sure the meaning of measure 3. you want to calculate value when InitiatingOrg is equal to EndingOrg and InitiatingOrg is not equal to EndingOrg. Seems conflicting.
Hope this will help.
Thank you.