Forum Discussion
Ranking issue when filtering
Hi, I'm running into an issue when using the RANKX function within a table, and then filtering that table. Unfiltered, it works great, no issues with the actual ranked output field/column. But th...
NB_Data , Sum of discharge should not change with the filter for hospital/institution
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
Hi amitchandak , unfortunately I can't easily create a de-identified dummy pbix to work with. The first screenshot is in table/matrix format, with institution and discharges being fields from the dataset, and the others being measures.
I can't be the only one that's experienced this table/matrix filtering issue.
