Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear All,
i am new in PBI and can't to solve my problems.
We have two simple data sets (KPI & Point).
We have statistic-measure (stat_wei) in the matrix.
Using filtering, we need select any column (point> value). How to calculate a measure (my_point) equal to the difference between my column and other columns.
In example, we was choise Point A2 and need to calclucate difference statistics [stat_wei], between A2 and other columns (point A1,A2,B1,B2).
PS.
The data is very large ~10 000 000 rows (csv file)
Have any ideas?
Thanks,
Stanislav
Link to PBIX file
My mesure stat_wei:
stat_wei =
VAR base_wei=CALCULATE(sum('kpi'[weight]),ALLSELECTED('kpi'[val_cat]))
VAR count_wei=sum('kpi'[weight])
VAR mean_wei=SUMX('kpi','kpi'[val_num]*'kpi'[weight])/base_wei
RETURN IF(AVERAGE('kpi'[val_type])=1,mean_wei,count_wei*100/base_wei)
Example of KPI table:
Example of Point table:
Solved! Go to Solution.
Hi All
I found a solution for this problem!
We must create two measures (raw & my) that will be calculated correctly:
raw = CALCULATE([stat_wei],REMOVEFILTERS(my_point))
my = CALCULATE([stat_wei],ALLSELECTED(point[val_cat],point[point]))
@StenX ,
Not sure what's the expected result you want to achieve, but you can refer to the similar cases below:
https://community.powerbi.com/t5/Desktop/Difference-between-2-columns-in-Matrix/td-p/374710
https://community.powerbi.com/t5/Desktop/Difference-between-2-columns-in-a-Matrix-Table/td-p/81614
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dear Jimmy,
Thanks for the links, but I'm afraid they will not help in my problem ((
Hi All
I found a solution for this problem!
We must create two measures (raw & my) that will be calculated correctly:
raw = CALCULATE([stat_wei],REMOVEFILTERS(my_point))
my = CALCULATE([stat_wei],ALLSELECTED(point[val_cat],point[point]))
User | Count |
---|---|
94 | |
79 | |
74 | |
63 | |
59 |
User | Count |
---|---|
110 | |
101 | |
84 | |
64 | |
62 |