Forum Discussion
Chavas
Helper II
Helper IICalculate average per month based on status
Hello all. I am struggling with a metric which should be easy, but I do not know why it is not showing the information. I have a table with the connection status of multiple entities. Each row mea...
I had the visual filtered. Once removed the filter it starts to work.
I had created one metric for each status.
amitchandak
Super User
Super UserChavas , Not very clear. Can you share sample data and sample output in a table format?
refer if this can help https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390
ChavasSure, first thing first. There was a Typo, now it is showing all as 1
Visual with Metric applied
Sample of table:Entity Code DATE Connection Status 1 11-08-19 A 2 11-08-19 A 3 11-08-19 B 1 11-08-20 A 2 11-08-20 B 1 12-08-20 B 2 12-08-20 C 1 01-09-20 A 2 01-09-20 B 3 01-09-20 C - Chavas
My bad...
God, visual filter was applying to the measure that is why it was not working propery.
So, is anyway that I can avoid hardcoding the Filter on the metric and set it on the visual?