Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have a scenario where need to list the distinct regions through multiple columns (Impacted Site.A, Impacted Site. B, etc) and also count how many times they show up in those columns. Can you please advise how it can be done with Power BI?
Thanks.
Solved! Go to Solution.
Hi @Krisztian,
In this scenario, please try this DAX formula to create a calculated table. Add a new column, specify a non-blank value for it.
Table = UNION ( SELECTCOLUMNS ( Site, "SiteList", Site[Impacted Site.A] ), SELECTCOLUMNS ( Site, "SiteList", Site[Impacted Site.B] ), SELECTCOLUMNS ( Site, "SiteList", Site[Impacted Site.C] ), SELECTCOLUMNS ( Site, "SiteList", Site[Impacted Site.D] ), SELECTCOLUMNS ( Site, "SiteList", Site[Impacted Site.E] ) )
Column = 1
Then, drag a table visual in your report.
Thanks,
Yuliana Gu
Hi @Krisztian,
In this scenario, please try this DAX formula to create a calculated table. Add a new column, specify a non-blank value for it.
Table = UNION ( SELECTCOLUMNS ( Site, "SiteList", Site[Impacted Site.A] ), SELECTCOLUMNS ( Site, "SiteList", Site[Impacted Site.B] ), SELECTCOLUMNS ( Site, "SiteList", Site[Impacted Site.C] ), SELECTCOLUMNS ( Site, "SiteList", Site[Impacted Site.D] ), SELECTCOLUMNS ( Site, "SiteList", Site[Impacted Site.E] ) )
Column = 1
Then, drag a table visual in your report.
Thanks,
Yuliana Gu
this works except, it's not being filtered by my report level filters, it seems since all the values come from a table that is being filtered it should work, any pointers on the filtering?
Thanks Yuliana, works perfectly, appreciate your assistance!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |