cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MichaelV Frequent Visitor
Frequent Visitor

Percentage Difference between cards

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 Smiley Happy 

 

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? 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Percentage Difference between cards

Hi @MichaelV,

 

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




1 REPLY 1
Super User
Super User

Re: Percentage Difference between cards

Hi @MichaelV,

 

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!