The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.