Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everyone,
Using PowerBI Desktop, I wonder If I can hide the values showing up in red area below :
I want to keep the total of each CS Average theoretical_value_for_tr and Average of Overriden_value, but don't want the detail for every sub value of CS.
Regards
Hello and thank you for a quick answer ! Sorry for my lack of knowledge, but I'm not getting the end of the measure :
I tried to set the Overriden valeur as last parameter of the measure, but it is not working. Can you explain a little bit more so I understand this part ?
After BLANK(),SUM(your column))
Proud to be a Super User! | |
Ok I understand now.
Unfortunately I have this error when trying to put the measure in the matrix :
Calculation error in measure 'Mesures'[measure]: Function 'CONTAINSROW' does not support comparing values of type Text with values of type Number.
The Overriden and theoretic value are set as decimal number, because I need to get the total of it at some point, so I cannot set it to Text.
I also tried :
If you have any more ideas, i'll take it !
@RomainBSNP
Is it working now?
Proud to be a Super User! | |
Seems like we replied at the same time approximatively. See my post above :).
Hi @RomainBSNP
Create a measure like (Item is the column which holds data line ACTUAL_PICES ect)
Measure = VAR _Item = SELECTEDVALUE(Table[Item])
RETURN
IF(
_Item IN {"ACTUAL_PICES","----","----",so on},BLANK(),YourMeasure or Value COl)
Let me know if that works for you
If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.
Thanks
Pijush
Linkedin
Proud to be a Super User! | |
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
70 | |
70 | |
38 | |
28 | |
26 |
User | Count |
---|---|
97 | |
88 | |
59 | |
43 | |
40 |