Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

adjusting quick measure

Im using quick measure and want to make a small adjustment instead of IN i want to choose the whole table..    how do i go about doing that ?   Count of BICUST difference from 1, 10, 1000,...
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI 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