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.
Hello everyone,
I have multiple tables in my model that contain binary values or codes that need to be translated to a corresponding label. For example, I have a client table, where the type can be 0 or 1, which means "Loyal" and "Other", or a country table where if the value is 1, it's France, if 2, it's England, 3 is Germany, etc.
I have a table that I want to use to transcore these values that looks like this :
Entity | Code | Label |
Client | 0 | Other |
Client | 1 | Loyal |
Country | 1 | France |
Country | 2 | England |
... | ... | ... |
My goal was to join the transcoding table to my other tables on the code, with the condition that the entity is the right name. In SQL, I would type :
select Label from transcode
where transcode.Code = Client.client_type
and transcode.Entity = "Client";
But I don't know how to achieve this in Power BI so that I can use labels instead of the codes in each table to build my report.
Thank you all !
@Lausaurine , we will join these two tables on code and cliend type and create one measure and use that with label in table visual
calculate(COunt(transcode[Label]), filter(transcode, transcode[Entity] = "Client" ))
refer if needed
DAX vs SQL: https://www.youtube.com/watch?v=WlvQ_SGy4iA&list=PLPaNVDMhUXGZNyKU0PgG2g3P0c6CPjMnj
User | Count |
---|---|
73 | |
70 | |
38 | |
25 | |
23 |
User | Count |
---|---|
96 | |
93 | |
50 | |
43 | |
42 |