Percentage Difference between cards

[Anonymous]

Hello, I am having trouble creating a measure that would display the percentage difference between two cards I have. Both cards are of the same aggregated fact, but one of the cards is filtered by a slicer. Is there any measure/formula that would let me create a percentage difference from the filtered card to the non-filtered one that would also update with each item I choose in the slicer? I tried creating a quick measure, but that only filters by one value, and I'd need it to update with the different filters I have in my slicer. I have also tried out other methods on here that I saw ( for example: Operate with 2 cards), and none of them worked out. Any help would be appreciated 🙂 

Edit:

With the quick measure I am able to get this measure :

Count of BlockId % difference from Corporation =
VAR __BASELINE_VALUE =
    CALCULATE(
        DISTINCTCOUNT('Data'[BlockId]),
             'Data'[Manufacturer] IN { "Corporation" }
)
VAR __MEASURE_VALUE = DISTINCTCOUNT('Data'[BlockId])
RETURN
    IF(
        NOT ISBLANK(__MEASURE_VALUE),
              DIVIDE(__BASELINE_VALUE, __MEASURE_VALUE)
)

Is there anyway to change this so that "Corporation" could be anything I choose from a slicer and not be specific to this manufacturer? 

[MFelix · Accepted solution]

Hi @Anonymous,

Assuming that you have the value from the slicer is based on the column Manufacturer try to change your measure to the one below the bold part of the measure is what is different:

Count of BlockId % difference from Corporation =
VAR __BASELINE_VALUE =
    CALCULATE(
        DISTINCTCOUNT('Data'[BlockId]),
          ALLSELECTED(   'Data'[Manufacturer] )
)
VAR __MEASURE_VALUE = DISTINCTCOUNT('Data'[BlockId])
RETURN
    IF(
        NOT ISBLANK(__MEASURE_VALUE),
              DIVIDE(__BASELINE_VALUE, __MEASURE_VALUE)
)

Regards,

MFelix