Facing Compare Issue in powerBI

Question

I am trying to compare the response time to two releases of the product. But when I trying to create the comparison table, I am facing issue. In the below picture 1 you can see that, both release filter is applied and is giving value when I have selected the same release but when I change the release version, I am not able to see the data, which you can see in picture 2.

Simply when we select the same value in the slicer it is giving value else not.

In below,

new_release_id is the field in release table i.e release_id which is converted into slicer

old_release_id is the new column with name Rel_Column which duplicates the value of release_id of the release table.

I made two fields with the same value so that I can use the SELECTEDVALUE feature in the DAX uniquely.

In the table comparision,

sample_name is the field in response_time table

NewReleaseAverage is the calculated field in the response_time table and the DAX is -

NewReleaseAverage = CALCULATE( AVERAGE('public response_time'[average]), 'public response_time'[release_id] = SELECTEDVALUE('public release'[release_id]) )

Similarly, OldReleaseAverage is the calculated field in the response_time table and the DAX is -

OldReleaseAverage = CALCULATE( AVERAGE('public response_time'[average]), 'public response_time'[release_id] = SELECTEDVALUE('public release'[Rel_Column]) )

Picture 1

Picture 2

Andrii · Accepted Answer · 2024-02-28 08:08:25Z

0

The result could be blank because there are no rows that satisfy both filter conditions.

To mitigate, you can either create a new table for the "old release" slicer (with the same data) or can try using ALL() function to clear filters, something like:

OldReleaseAverage = CALCULATE(
    AVERAGE('public response_time'[average]),
    ALL('public release'),
    'public response_time'[release_id] = SELECTEDVALUE('public release'[Rel_Column])
)

answered Feb 28, 2024 at 8:08

Andrii

6365 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Facing Compare Issue in powerBI

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related