Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have a question regarding the outcome of a query.
DEFINE
MEASURE 'Source'[DistinctCount] = DISTINCTCOUNT('Source'[Source])
MEASURE 'Allocation'[DistinctCountRows] =
COUNTROWS ( FILTER ( VALUES ( Source[Source] ), COUNT('Allocation'[QUANTITY]) > 0 ) )
MEASURE 'Allocation'[AllocationNew] =
IF(
--ISFILTERED('Source'[Source]) && DISTINCTCOUNT('Source'[Source]) > 1
COUNTROWS ( FILTER ( VALUES ( Source[Source] ), COUNT('Allocation'[QUANTITY]) > 0 ) ) > 1
,"N/A (multiple sources selected)"
,IF(
COUNTROWS ( FILTER ( VALUES ( Allocation[LINEPACK_ALLOCATION_TYPE_ID] ), COUNT('Allocation'[QUANTITY]) > 0 ) ) > 1 && NOT ISBLANK('Allocation'[Allocation Count]),
--DISTINCTCOUNT(Allocation[LINEPACK_ALLOCATION_TYPE_ID]) > 1 && NOT ISBLANK('Allocation'[Allocation Count]),
"N/A (multiple allocation types selected)",
SUM('Allocation'[QUANTITY])
)
)
EVALUATE
SUMMARIZECOLUMNS
(
Source[Source],
"Sources", CALCULATE('Source'[DistinctCount])
,"Countrows of sources", CALCULATE('Allocation'[DistinctCountRows])
,"AllocationNew", CALCULATE('Allocation'[AllocationNew])
)This results in:
When I put Source in comment the result is:
Though the desired result is [countrows of sources] = 1 and [AllocationNew] should contain a value, because there is only 1 source with a value. I think i'm almost there, but can't figure out what is wrong.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 7 | |
| 6 | |
| 5 | |
| 5 |
| User | Count |
|---|---|
| 24 | |
| 11 | |
| 9 | |
| 9 | |
| 8 |