The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Below table consists of Innovations, Quality, Services which are column names and the Year23, Year24, Quater1 24, Quater2 24 are the calculated measures:-
Year23 | Year24 | Quater1 24 | Quater2 24 | |
Innovations | 5 | 5 | 5 | 5 |
Quality | 6 | 6 | 6 | 6 |
Services | 7 | 7 | 7 | 7 |
In the above table i want to add individual row called #FORMS that means total number of forms submitted, and it should look like the below table:-
Year 23 | Year24 | Quater1 24 | Quater2 24 | |
Innovations | 5 | 5 | 5 | 5 |
Quality | 6 | 6 | 6 | 6 |
Services | 7 | 7 | 7 | 7 |
#FORMS | 4 | 4 | 1 | 1 |
That's two red flags for the price of one. What you are trying to do is against the Power BI design. Consider to continue using Excel for this requirement.
User | Count |
---|---|
16 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
24 | |
13 | |
13 | |
8 | |
8 |