Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
88 | |
74 | |
69 | |
65 | |
58 |
User | Count |
---|---|
104 | |
94 | |
76 | |
62 | |
59 |