Forum Discussion

ayush_mriti's avatar
ayush_mriti
Helper I
1 year ago
Solved

Filter in DAX calculation

Hi All,   This is the Dax calculation and the output. I need to create a Dax calculation which only shows the highlighted column ( Agile-Scrum with 77.42%). In the below calculation I used ALL, so ...
Need Help
  • MarkLaf's avatar
    MarkLaf
    1 year ago

    If you want the measure to behave the same and just control where it is displayed:

     

     

    IF( 
    ( "Software Delivery", "Agile-Scrum" ) IN 
    SUMMARIZE( 
        'Teams Output Final_Current', 
        'Teams Output Final_Current'[Delivery_Type],
        'Teams Output Final_Current'[Team_Type] 
    ), 
    <YOUR MEASURE>
)

     

     

     

    And you can alternatively add a slicer, filter to the desired values, then hide the slicer (and disable slicer's interactions with other visuals as needed). per Ashish_Mathur's point, just use the filter pane.

ayush_mriti's avatar
ayush_mriti
Helper I
1 year ago

Hi Mark, 

thanks for the calculation, I have change few things to get the desired output.