Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.
Would appreciate it if someone could correct my error in the following DAX script:
Solved! Go to Solution.
Hi @pmcinnis
try
res ct finished =
CALCULATE(
COUNTROWS('Data'),
FILTER(
ALLEXCEPT('Data','Data'[Parameter]),[Sample Type]="TREATED WATER" || [Sample Type]="DISTRIBUTION"))
or
res ct finished =
CALCULATE(
COUNTROWS('Data'),
FILTER(
ALLEXCEPT('Data','Data'[Parameter]),OR([Sample Type]="TREATED WATER", [Sample Type]="DISTRIBUTION")))
or
res ct finished =
CALCULATE(
COUNTROWS('Data'),
FILTER(
ALLEXCEPT('Data','Data'[Parameter]),[Sample Type] IN {"TREATED WATER", "DISTRIBUTION"}))
Hi @pmcinnis
try
res ct finished =
CALCULATE(
COUNTROWS('Data'),
FILTER(
ALLEXCEPT('Data','Data'[Parameter]),[Sample Type]="TREATED WATER" || [Sample Type]="DISTRIBUTION"))
or
res ct finished =
CALCULATE(
COUNTROWS('Data'),
FILTER(
ALLEXCEPT('Data','Data'[Parameter]),OR([Sample Type]="TREATED WATER", [Sample Type]="DISTRIBUTION")))
or
res ct finished =
CALCULATE(
COUNTROWS('Data'),
FILTER(
ALLEXCEPT('Data','Data'[Parameter]),[Sample Type] IN {"TREATED WATER", "DISTRIBUTION"}))
Thanks!
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
74 | |
70 | |
70 | |
45 | |
41 |
User | Count |
---|---|
48 | |
47 | |
29 | |
28 | |
28 |