Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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 |
---|---|
105 | |
69 | |
48 | |
47 | |
47 |