Forum Discussion

nicolast29's avatar
nicolast29
Icon for Helper V rankHelper V
4 years ago
Solved

Filter with a dax (neebee question)

Hi

first sorry for this question who is perhaps so simple for you

 

I have a table and i use the filter panel to filter on the cretea actif /passif, i work as i want

 

 

 

But want to do more and filter with a dax function and not use the filter panel

If someone can give me the direction in order to replace my value agreagation by a measure

https://1drv.ms/u/s!AoqtZHsX4Bzvg_t-D8Jh1acx3_roPg?e=zTTveC 

 

thanks

Nicolas du 29

Need Help
  • ITManuel's avatar
    ITManuel
    4 years ago

    HI nicolast29 ,

     

    you could use the calculate function to restrict the calculation of "Solde N k€" and ""Solde N1 k€" to a condition you want.

     

    Best regards

4 Replies

  • ITManuel's avatar
    ITManuel
    Icon for Responsive Resident rankResponsive Resident
    4 years ago

    HI nicolast29 ,

     

    you could use the calculate function to restrict the calculation of "Solde N k€" and ""Solde N1 k€" to a condition you want.

     

    Best regards

    • nicolast29's avatar
      nicolast29
      Icon for Helper V rankHelper V
      4 years ago

      ok

      i was wrong searching to do it on the agragtion, it is not possible here ? as in the panel

      • ITManuel's avatar
        ITManuel
        Icon for Responsive Resident rankResponsive Resident
        4 years ago

        Not sure if I get you right.

         

        From what I know you cannot add a filter to the visual (to be used in the visual itself). Try adding a slicer the report and us Actif/Passif in the slicer. Maybe this is what your are looking for.

         

        Br