Forum Discussion

H3nning's avatar
H3nning
Icon for Helper V rankHelper V
2 years ago
Solved

Measure not affected by Slicer

Hi, i have this measure and I wonder why it is not affected by my slicer A and B COUNTROWS(                     FILTER(                         SUMMARIZE(FILTER(ALLEXCEPT(Werte_kurz,Firmendimens...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi H3nning ,

    The Table data is shown below:

    The relationship between tables is as follows:

    Regarding your question, there should be a problem with the dax expression you provided, please follow these steps:
    1. Use the following DAX expression to create a measure (Replace 'Date(2024.2.1)' and 'Date(2024.2.15)' with 'MinDatum' and 'MaxDatum' in the expression)

    Measure = CALCULATE(
    COUNTROWS(
        FILTER(
            SUMMARIZE(FILTER('Werte_kurz','Werte_kurz'[StartDatum] >= DATE(2024,2,1) && 'Werte_kurz'[EndDatum] <= DATE(2024,2,15)),[Firma]),
            NOT(ISBLANK('Werte_kurz'[Firma])))),ALLEXCEPT(Werte_kurz,'Firmendimension'[A],'Firmendimension'[B]))

    2. Final output ("Measure2" is the dax expression you supplied.)

    Best Regards,
    Wenbin Zhou
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi H3nning ,

The Table data is shown below:

The relationship between tables is as follows:

Regarding your question, there should be a problem with the dax expression you provided, please follow these steps:
1. Use the following DAX expression to create a measure (Replace 'Date(2024.2.1)' and 'Date(2024.2.15)' with 'MinDatum' and 'MaxDatum' in the expression)

Measure = CALCULATE(
    COUNTROWS(
        FILTER(
            SUMMARIZE(FILTER('Werte_kurz','Werte_kurz'[StartDatum] >= DATE(2024,2,1) && 'Werte_kurz'[EndDatum] <= DATE(2024,2,15)),[Firma]),
            NOT(ISBLANK('Werte_kurz'[Firma])))),ALLEXCEPT(Werte_kurz,'Firmendimension'[A],'Firmendimension'[B]))

2. Final output ("Measure2" is the dax expression you supplied.)

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

H3nning's avatar
H3nning
Icon for Helper V rankHelper V
2 years ago

Thank you Anonymous ! Funny thing I tried this, but kept the allexept in the the place where i had it in the original expression. So two times allexept, one in the spot of my original expression and one as in the solution. Like this:

CALCULATE(
    COUNTROWS(
        FILTER(
            SUMMARIZE(FILTER(ALLEXCEPT(Werte_kurz,'Firmendimension'[A],'Firmendimension'[B]),'Werte_kurz'[StartDatum] >= DATE(2024,2,1) && 'Werte_kurz'[EndDatum] <= DATE(2024,2,15)),[Firma]),
            NOT(ISBLANK('Werte_kurz'[Firma])))),ALLEXCEPT(Werte_kurz,'Firmendimension'[A],'Firmendimension'[B]))

That didn't work out and slicer didnt work, although the measure did not throw any errors. Can someone explain why?