Forum Discussion
Measure Anzahl einer Spalte
- Anonymous2 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.
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.