cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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 🙂 

 

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
MFelix
Super User III
Super User III

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


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

1 REPLY 1
MFelix
Super User III
Super User III

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


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors