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 dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have two distinctcount measures which I'd like to display in the same visual.
For example, if the value of the first calculated measure equates to 27 and the second is 73, I would like it show in the visual as "27/73 Clients." Is this possible?
Solved! Go to Solution.
@js124 ,
It is. I created 2 measures, one equal to 27 and the other 73. Created a third to concatenate the results.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
m3 = CONCATENATE([m1],Concatenate("/",CONCATENATE([m2]," Clients")))
Proud to be a Super User!
@js124 ,
It is. I created 2 measures, one equal to 27 and the other 73. Created a third to concatenate the results.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
m3 = CONCATENATE([m1],Concatenate("/",CONCATENATE([m2]," Clients")))
Proud to be a Super User!
User | Count |
---|---|
14 | |
9 | |
7 | |
7 | |
6 |
User | Count |
---|---|
22 | |
11 | |
10 | |
10 | |
8 |