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.
Hey,
I am trying to show in each line the count of rows that have the same downtime ID, but so far no luck.
The image below is what I expected to have, but due to the exising columns from a dimension table I have not been able to get the desired result, and I need those dimmensions columns on the table. How can I achieve the desired result?
Link to the file: https://we.tl/t-K8UReNHWtR
Thanks
André
Solved! Go to Solution.
maybe you can try this
=calculate(countrows(table),allexcept(table, downtimeid))
Proud to be a Super User!
Hi @afbraga66 ,
As @ryan_mayu said, you can apply this code to solve your problem. I am adding a small step here, before adding this code you can merge two tables on one table, this will give you better results as you want:
Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
PBI file attached.
Hope this helps.
Hi @afbraga66 ,
As @ryan_mayu said, you can apply this code to solve your problem. I am adding a small step here, before adding this code you can merge two tables on one table, this will give you better results as you want:
Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
maybe you can try this
=calculate(countrows(table),allexcept(table, downtimeid))
Proud to be a Super User!
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |