Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |