Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Values |
Apple |
Apple |
Apple |
Orange |
Orange |
Orange |
Grapes |
Grapes |
Grapes |
Grapes |
Bnana |
Pear |
Pear |
Pear |
Pear |
Kiwi |
Kiwi |
Kiwi |
Kiwi |
Result I wanted via measure is: How many Times Values is repeated
Please see the image below for refrence:
Hi @Anonymous
Please see the below.
Measure = VAR _duplicates = CALCULATE( COUNTROWS( Fruits ), ALL( Fruits ), VALUES( Fruits[Fruit] ) ) RETURN IF( _duplicates > 1, _duplicates )
Hi @Anonymous
If you working with direct query you need to use composite models:
1. use aggregated tables to create a table with apples, bananas etc. and count on them.
2. add segmentation tables with 0 Times, 3 Time etc and create a measure to calculate.
3. add table calculated from Direct query table but don't know if this can be done.
calculated column 1
Occurrences=
VAR thisValue=Table[Value]
RETURN
COUNTROWS(Filter(Table;Table[Values]=thisValue
Calculated column 2
Occurrences of This Value=
VAR thisOcc=Table[Occurrences]
RETURN
DISTINCTCOUNT(SELECTCOLUMNS(Filter(Table;Table[Occurrences]=thisOcc);Value))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |