Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
7 | |
6 |