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.
i have the next situation and thank you in advance.
i have the next table,
it's conformed by a Client and 4 measures, income amount in this period, income amount in a comparation period, diference and %, i want to get a global measure where indicate me the total of non invoiced thats means i invoiced last period but no in this.
the main idea is like
Prueba = CALCULATE([Ingresos Var],[Operaciones %]<=-1), But i can´t use it cause is a true / false in a calculate.
i tried with
IF([Ingresos_Actuales]<=0,[Ingresos Var],""), but it is not helpful because in the main total incomes in this period are bigger, it works if i select a single customer but i'm looking for somthing that acumulate the [Ingresos Var]
I hope to have me explained
@RcelsoP,
Please change your DAX to the following, if it still doesn't return your expected result, please share sample data of your original table and post desired result here.
Prueba = CALCULATE([Ingresos Var],FILTER(Yourtable,[Operaciones %]<=-1))
Regards,
Lydia
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 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |