Is there any way to get which column is selected in a table for sorting
Say I have a table like below. Open Job Tables Currently sorted by Job Name Date Job (selected to sort by) Status name 10 7/1/22 dax measure open Name 2 3/1/22 visual formating closed and I would like to create a measure that would return the Table name and which column is selected to sort the table. I know that I can use SelectedValue to return what is selected in a slicer. Is there a way to find out what column is selected in a table for sorting?
Percentage between two columns
Good day, I have two tables, related to each other by fist column (name of the source file). I'm looking for measure to show me how many "RISK and HIGH RISK" checks were done comparing to "none or standard". Result should be in procents and filtered by year (2021) SOURSE FILE NAME REASON FOR CHECK SOURSE FILE NAME Date of Check 1 none 1 2020 2 risk 2 2020 3 high risk 3 2021 4 none 4 2021 5 standard 5 2021 6 risk 6 2021 For example in 2021 there were 4 checks where two of these were (Risk/High Risk) - final result is 50% in 2021. Thnaks Aleks