This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
I have a report in Power bi where I show information from different countries, when I select a city it shows me the information from only that country, but I want it to make a sum of the information from the last quarter when no city is selected.
But I already have a dax function and I would just like to add that parameter
INDU_INVENTARIO =
/*Variables para seleccionar el idiona*/
VAR Seleccion = SELECTEDVALUE(IDIOMAS[Idioma])
/*Variables para encontrar el ultimo registro en base a la columna de fecha y el valor buscado */
var _lastDateMetro = MAXX(FILTER(Industrial_Latam,NOT(ISBLANK(Industrial_Latam[Inventario Industrial (m²)]))),Industrial_Latam[Fecha])
var _lastDateSQF = MAXX(FILTER(Industrial_Latam,NOT(ISBLANK(Industrial_Latam[Inventario Industrial (sqf)]))),Industrial_Latam[Fecha])
/*Varibles donde se guarda el ultimo valor ecncontrado*/
var Metro = MAXX(FILTER(Industrial_Latam,Industrial_Latam[Fecha]=_lastDateMetro),Industrial_Latam[Inventario Industrial (m²)])
var SQF = MAXX(FILTER(Industrial_Latam,Industrial_Latam[Fecha]=_lastDateMetro),Industrial_Latam[Inventario Industrial (sqf)])
Var SUM_INV = MAXX(FILTER(Industrial_Latam,Industrial_Latam[Fecha]=_lastDateMetro),SUM(Industrial_Latam[Inventario Industrial (sqf)]))
Var Formato =
SWITCH (
TRUE,
Seleccion = "ESP", Metro,
Seleccion = "ENG", SQF,
SUM_INV
)
return Formato
How could I add that parameter while respecting the other conditions?
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 32 | |
| 25 | |
| 23 | |
| 22 | |
| 13 |
| User | Count |
|---|---|
| 61 | |
| 47 | |
| 27 | |
| 24 | |
| 19 |