Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I want to show the row value for each selection. the file is here: https://we.tl/t-LcWJHkuk62 If nothing is selected, the default value should be shown based on Value[Rel]=”V”. For example,
Solved! Go to Solution.
PlanTestExcel = if (isfiltered(CityTable)||ISFILTERED(RegionTable)||ISFILTERED(TownTable),sum(Main[Value1]),CALCULATE(sum(Main[Value1]),Main[Rel]="V"))
User | Count |
---|---|
143 | |
71 | |
69 | |
53 | |
52 |
User | Count |
---|---|
208 | |
94 | |
64 | |
60 | |
57 |