The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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:
KPI table
Example of Point table:
Point table
My screen
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 |
---|---|
86 | |
84 | |
35 | |
35 | |
35 |
User | Count |
---|---|
94 | |
79 | |
63 | |
55 | |
52 |