Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
What is the equivalent dax for the following query?
(COUNTIF($B$1:$B1,$B1)=1)+0
Solved! Go to Solution.
Hi @spereira,
Using a measure as below:
Measure =
VAR a=CALCULATE(COUNT('Table'[B]),FILTER('Table','Table'[B]="$B1")))
Return
IF(a=1,a+0,BLANK())
Hi @spereira,
Using a measure as below:
Measure =
VAR a=CALCULATE(COUNT('Table'[B]),FILTER('Table','Table'[B]="$B1")))
Return
IF(a=1,a+0,BLANK())
countx(filter(table,table[Column]="abc"),table[column])
countx(filter(table,table[Column]=table[column2]),table[column])
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |