Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi, I'm trying to replicate this table format on PowerBI table visual:
I have created Measure1 as follows:
Measure1 = CALCULATE(COUNT('Table'[Request Number]))
and I put it on G column that is the value of each Field2 in column F in each month. What I want to do is to calculate column E by the same measure grouped by Field1 (column C) for each month. So for example on the first row of column E we have 11 for Field1=X and Month=January, that is 6+4+1 ofthe first three rows Column G, and so on.
I tried the GROUPBY or ALLEXCEPT functions by Month and Field1 but it didn't work.
How can I build the formula or use particular view for the visual to aggregate the column E by month and Field1?
it seems this table visual is impossible in Power BI. Only Matrix is a little similar to your request.
User | Count |
---|---|
13 | |
8 | |
8 | |
7 | |
5 |
User | Count |
---|---|
21 | |
15 | |
15 | |
10 | |
7 |