Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys - i just started with PowerBI Desktop and watched a couple of tutorials.
I created an "easy" measurement to calculate a %-Value from two-KPis.
The Problem is -> i want just one result and if i choose "summary" the calculation is wrong.
What is the problem to get the right result on the needed aggregation level?
Solved! Go to Solution.
Hi @PeterPain
You can try the following measure
Rate =
VAR a =
SUMX (
FILTER (
ALLSELECTED ( 'KPI' ),
[Datum]
IN VALUES ( 'KPI'[Datum] )
&& [SEITE] IN VALUES ( 'KPI'[SEITE] )
),
[Loss AI]
)
VAR b =
SUMX (
FILTER (
ALLSELECTED ( 'KPI' ),
[Datum]
IN VALUES ( 'KPI'[Datum] )
&& [SEITE] IN VALUES ( 'KPI'[SEITE] )
),
[Adreq.]
)
RETURN
DIVIDE ( a, b )
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @PeterPain
You can try the following measure
Rate =
VAR a =
SUMX (
FILTER (
ALLSELECTED ( 'KPI' ),
[Datum]
IN VALUES ( 'KPI'[Datum] )
&& [SEITE] IN VALUES ( 'KPI'[SEITE] )
),
[Loss AI]
)
VAR b =
SUMX (
FILTER (
ALLSELECTED ( 'KPI' ),
[Datum]
IN VALUES ( 'KPI'[Datum] )
&& [SEITE] IN VALUES ( 'KPI'[SEITE] )
),
[Adreq.]
)
RETURN
DIVIDE ( a, b )
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi and thx for your answer. "Rate" is a measure already 😊
Hello @PeterPain ,
try converting the table visual into a matrix and have the rate in the values and the other fields as rows.
Proud to be a Super User! | |
@PeterPain
Create a meaure instead of column for your calcualtion
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |