Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
hi, i've a trouble with a pwbi report. i need yo have a % mesure on each rows in the matrix below. the problem is when i calculate the % mesure in the subrows.
not all the rows are wrong but only the sub-rows, the column in error is the column Cons%
for this report i have used 2 different mesures:
Hi,
you shouldn't use the / to make division but use the function divide 🙂
try
Cons% = DIVIDE(ABS(BILANCIO[Cons]),MISURE[Ricavi])
it should solve your case...
isn't ok.
With DIVIDE function the result is this. i don't see the text "infinito" but however i don't see the % value.
i think the problem consist in the relation with the tables.
User | Count |
---|---|
77 | |
70 | |
69 | |
54 | |
48 |
User | Count |
---|---|
42 | |
37 | |
34 | |
31 | |
28 |