adjusting quick measure

Question

Im using quick measure and want to make a small adjustment instead of IN i want to choose the whole table..&nbsp;&nbsp;how do i go about doing that ?&nbsp;Count of BICUST difference from 1, 10, 1000, 10002, 10005, 10006, 10008, 10009, 1002, 1003, or 10034 = VAR __BASELINE_VALUE =&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DISTINCTCOUNT('VBISALES (2)'[BICUST]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'VBISALES (2)'[BIITEM] IN {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"1",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"10",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"1000",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"10002",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"10005",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"10006",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"10008",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"10009",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"1002",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"1003",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"10034"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;)VAR __MEASURE_VALUE = DISTINCTCOUNT('VBISALES (2)'[BICUST])RETURN&nbsp;&nbsp;&nbsp;&nbsp;IF(NOT ISBLANK(__MEASURE_VALUE), __MEASURE_VALUE - __BASELINE_VALUE)

samdthompson · Answer

Hello, try making this measure:&nbsp;DistinctBICUST=DISTINCTCOUNT('VBISALES (2)'[BICUST])&nbsp;&nbsp;

anonymous · Answer

thanks for that suggestion, didnt work though. I remember trying that&nbsp;

samdthompson · Answer

Are you able to describe whats not working about that? Its just the core part of the calculation without the filtering.&nbsp;&nbsp;

anonymous · Answer

HI&nbsp;Anonymous,
You can use all functions to extract the target table field values and compare them with your expressions:
Count of BICUST difference From Table =
VAR __BASELINE_VALUE =
    CALCULATE (
        DISTINCTCOUNT ( 'VBISALES (2)'[BICUST] ),
        'VBISALES (2)'[BIITEM] IN ALLSELECTED ( Table[Column] )
    )
VAR __MEASURE_VALUE =
    DISTINCTCOUNT ( 'VBISALES (2)'[BICUST] )
RETURN
    IF ( NOT ISBLANK ( __MEASURE_VALUE ), __MEASURE_VALUE - __BASELINE_VALUE )
Regards,
Xiaoxin Sheng

Forum Discussion

adjusting quick measure

4 Replies

Related content

Quick Measure to be adjusted

Recursive loop Measure /Auto Adjustable Measure /Circular Dependency Issue While Adjusting values

Adjust this measure to show totals

Quick Measure

How to hide Quick Measure pane