Forum Discussion

Flo95's avatar
Flo95
Frequent Visitor
2 years ago
Solved

Measure Anzahl einer Spalte

Hallo zusammen,   ich benötige ein Measure mit welchem ich die Anzahl der Mitarbeiter eines bestimmten Wertes aus einer Spalte bestimmen kann: Folgendes Beispiel: Ich benötige nun das Measure mit ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    hi, Flo95 

    I'm happy to answer your questions. here is my solution:

    We can create a measure to be used in conjunction with slicer for dynamic filtering,Here is my DAX expression:

    Count of Rolle = 
    CALCULATE(
                COUNTA('Tabelle1'[Rolle]),
                FILTER(
                            ALLSELECTED('Tabelle1'[Rolle]),
                            ISONORAFTER('Tabelle1'[Rolle], MAX('Tabelle1'[Rolle]), DESC)
                )
    )
    

    A screenshot of the formula is shown below:

    The slicer settings are as follows:

    The results are as follows:

     

     

     

    How to Get Your Question Answered Quickly

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Jianpeng Li

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