Forum Discussion

Ratax's avatar
Ratax
Icon for Helper I rankHelper I
4 years ago

Table visual showing different total compared to mesaure when a single record is selected

So i have this table showing 2 measures that calculates percentile 25 and percentile 95. When i have a single record selected the total is not showing the same as the measure   My question no...
Need Help
Ratax's avatar
Ratax
Icon for Helper I rankHelper I
4 years ago

parry2k Thanks for your reply.

From my understanding the row filter is passed to the filter context when the Calculate function is used.

i attached this screendump. 

 

From what i can see the Total on the table visual is showing the correct value where the row filter is passed to the filter context.

it's the row in the table this is showing the wrong value. 

 

Statement:

The row filter is passed to the filter context in the total of the table.

In the row is the table the row filter is not passed to the filter context.

Is this statement correct? 

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Ratax ,

     

    Have your problem been solved, if yes, you could share your solution so that others can find the solution.

    If no, can you share your DAX expression of P25 Raw? Or the pbix file without sensitive data and I will check it.

     

    Best Regards

    Community Support Team _ chenwu zhu