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.
The problem is that i would like that when one of the categories in the P&L are highlighted, in another table should be shown the various accounts in that category. If CE2 stays without relationship, the second table won't of course filter anything.
Solved! Go to Solution.
as a follow up, the solution to this issue was switching the focus from the P&L visual to the other "accounts" table: there using an ad-hoc measure:
as a follow up, the solution to this issue was switching the focus from the P&L visual to the other "accounts" table: there using an ad-hoc measure:
hello @v-lionel-msft and thank you for your much appreciated hint!
I have tried changing the measures, the tables, etc, but without success.
I am really struggling to get the logic behind, because if i activate the relationship the measures of the subtotals don't work anymore, so there might be somehow an implicit filtering that i am not getting.
e.g. the first subtotal that points to '_Base'[Reddito operativo] is:
/* A - B del conto economico*/ CALCULATE ( '_Base'[Risultato d'esercizio], 'BilancioFULL'[Tipo] = "CE", 'Elenco'[Index] < 58 )
that calls [Risultato d'esercizio] which is
'_Base'[Ricavi] + '_Base'[Costi]
that in turn are:
Ricavi = CALCULATE(SUM(Conti[Saldo finale]), Conti[Natura] = "R", DATESYTD('Date'[Date]))
and
Costi = CALCULATE(SUM(Conti[Saldo finale]), Conti[Natura] = "C", DATESYTD('Date'[Date]))*-1
I am really getting crazy i have to admit 🙂
Thank you anyway for your comment.
Vittorio
Hi @nightfall ,
There seems to be no problem with the model, it may be a problem with the measure formulas.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |