Forum Discussion

ayush_mriti's avatar
ayush_mriti
Icon for Helper I rankHelper 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.

MarkLaf's avatar
MarkLaf
Icon for Super User rankSuper User
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
    Icon for Helper I rankHelper I
    1 year ago

    Hi Mark,

    For some reason its not providing me the correct output. it's showing 100% instead of 77.42%.