Ranking measures controlled by report filter

[GuilhemPFR]

Hi,

My dataset is showing 4 streams of expected revenues for 3 product lines and the dates when the revenues are expected to come in. I am calculating the NPV for each stream of revenues with a DAX calculation.

I have built a dashboard where the product line, the dates and the NPV can be filtered/modified and showing the resulting NPVs.

I am now trying to organise these NPVs in a list sorted by their values. Their ranking need to be recalculated when the slicers/filters values change.

I have tried the following:

1. Extracting the NPV values in a separate table to rank them. But then the report filters/slicers have no effect on the values in this table.

2. I haven't found how to calculate the NPVs in PowerQuery.

I would like to avoid Python or R...

You can find demo files here: guilhemPFR / powerbi-shared — Bitbucket

Any help appreciated 🙂

Edit 10/9: added link to files

[amitchandak]

@GuilhemPFR NAV1, NAV2, etc are measures?

Are you using these on the header of matrix?

[GuilhemPFR]

Yes NAV1, etc. are measures, calculated with a DAX function,

I am just displaying them in a table visual but I'll try a matrix.