count of latest and previous volumes ignoring selection

[Boja]

Hello good people 🙂

I want to calculate the difference in response count of different app versions. Based on the selection of the version on the bar chart, the table shoud show count of selected version, count of previous version and their difference.

 I have created a column assigning rank numbers to app versions (where the latest version has the rank of 1) and this is used in creating measures. My problem is that when one bar is selected count of the previous version is not displayed. Could you pease assist?

 

verMax= CALCULATE([# Feedback],
                   FILTER(BIReport, BIReport[rank ver] = MIN(BIReport[rank ver])
                    
)) 


ver(Max-1)= CALCULATE([# Feedback],
                   FILTER(ALLEXCEPT(BIReport,BIReport[AppVersion Corrected]), BIReport[rank ver] = MIN(BIReport[rank ver])+1
                    
))


Difference = [ver(Max-1)] - [verMax]

[v-xjiin-msft]

Hi @Boja,

Generally if we want to ignore the selection, we can add ALL() function. Like:

verMax= CALCULATE([# Feedback],
                   FILTER(ALL(BIReport), BIReport[rank ver] = MIN(BIReport[rank ver])
                    
)) 

By the way, could you please share us your pbix file with One Drive or Google Drive if possible? So that we can dig deeper and provide more proper suggestion.

Thanks,
Xi Jin.

[Boja]

Hi Xi Jin,

Thank you for assistance.

The ALL() funciton aggregates values based on app version. I dont need aggregation, but the distribution of responses (by Subtopics) as it is. So if i select version 8.19 on the bar chart, the table should show me subtopics distribution for 8.19 and 8.18.

Please find the link

DataSet