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.
@dofrancis3 Hi! Create a measure like:
D1_Percentage =
VAR Z_Value = LOOKUPVALUE( Table1[Z], Table1[Country], SELECTEDVALUE(Table2[Country]) )
RETURN DIVIDE( Table2[D1a] + Table2[D1b], Z_Value, 0)
D9_Percentage =
VAR Z_Value = LOOKUPVALUE( Table1[Z], Table1[Country], SELECTEDVALUE(Table2[Country]) )
RETURN DIVIDE( Table2[D9], Z_Value, 0)
MC1_Percentage =
VAR U_Value = LOOKUPVALUE( Table1[U], Table1[Country], SELECTEDVALUE(Table2[Country]) )
RETURN DIVIDE( Table2[MC1], U_Value, 0)
-- Repeat for other percentages using the same pattern
BBF
Dear @BeaBF ;
Please could you check again it doen't work it give me 0% will i have data
Please advise
Hi @dofrancis3 ,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |