Forum Discussion

D_PBI's avatar
D_PBI
Icon for Post Partisan rankPost Partisan
1 year ago
Solved

How to filter a table visual when the user clicks on a matrix value that is a measure?

Hi, I have a data table that contains many fields. These fields are placed in a table visual. Upon this data table, I create a DAX measure (as below) and this measure, along with other measures, ar...
Need Help
  • HarishKM's avatar
    HarishKM
    1 year ago

    D_PBI Hey,
    I have tried to recreate similer measure at my end.
    I am using this 

    Number group by date level(Cumulative) =
    CALCULATE (
        [PatentCount],  
        FILTER (
            ALL(PatientTable),  -- Remove filters to consider all rows in the table
            NOT (
                ISBLANK(PatientTable[FY]) || PatientTable[FY] = ""  -- Skip blank or empty FY
            ) &&
            VALUE(LEFT(PatientTable[FY], 4)) <= VALUE(LEFT(MAX(PatientTable[FY]), 4))  -- Compare years up to current max year
        )
    )
    when I select any perticular FY then my data is filtering as expected

    Could you try above new measure cummulative sum?

     

    Thanks
    Harish M
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

     

     

v-echaithra's avatar
v-echaithra
Icon for Community Support rankCommunity Support
1 year ago

Hi D_PBI ,

May I ask if you have gotten this issue resolved?

 

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

 

Regards,

Chaithra E.