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 ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,
Chaithra.