Forum Discussion

svp1000's avatar
svp1000
Frequent Visitor
1 year ago
Solved

Measure issue

Hi, I have a transaction table that has Region (Ex: APAC), Country (Ex: India), and a IS_IN_SLA (Yes or No), BU, and a bunch of other columns like submission date, etc. There is a slicer on the count...
  • v-veshwara-msft's avatar
    1 year ago

    Hi svp1000  ,

    You can try using selectedvalue in your DAX measure. This will specifically filter for the region that is selected.
    Dax_IN_SLA_Region =

     

    VAR SelectedRegion =

     

        CALCULATE(

     

            selectedvalue('TRANSACTION'[REGION])

     

        )

     

    RETURN

     

    CALCULATE(

     

        COUNTROWS('TRANSACTION'),

     

        'TRANSACTION'[IS_IN_SLA] = "Yes",

     

        'TRANSACTION'[REGION] = SelectedRegion,

     

        REMOVEFILTERS('TRANSACTION'[CLUSTER_NEW])

     

    )

     

    If you want multiple regions to be selected you can check out this solution on this post


    https://community.fabric.microsoft.com/t5/Desktop/display-multiple-elements-with-SELECTEDVALUE/m-p/650754

     

    Hope this helps. Please reach out for further assistance.

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.

     

    Thank you.