The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I'm beginner in DAX and I have a problem: a table called 'DVENDAS' with this columns: [Ticket], [Agency], [ServiceDate], [Service], [Source], [Destination], [Status] and more;
And I'm trying to create a new table with this idea: I have to SUMMARIZE this columns above, and FILTER by [Agency] AND [Status], but filtering Agency in two terms: "SITE" OR "PORTAL"; filtering Status only for "CHANGE".
Table = SUMMARIZE ( FILTER ( 'DVENDAS'; RELATED ( DVENDAS[Agency] ) = "SITE" || DVENDAS[Agency] = "PORTAL" && DVENDAS[Status] = "CHANGE" ); DVENDAS; DVENDAS[Ticket]; DVENDAS[Agency]; DVENDAS[ServiceDate]; DVENDAS[Service]; DVENDAS[Source]; DVENDAS[[Destination]; DVENDAS[Status] )
But I got error.
Please help 🙂
Solved! Go to Solution.
Hi @Anonymous,
Try this formula, please.
Table = CALCULATETABLE ( SUMMARIZE ( DVENDAS; DVENDAS[Ticket]; DVENDAS[Agency]; DVENDAS[ServiceDate]; DVENDAS[Service]; DVENDAS[Source]; DVENDAS[[Destination]; DVENDAS[Status] ); FILTER ( DVENDAS; DVENDAS[Agency] IN { "SITE"; "PORTAL" } && DVENDAS[Status] = "CHANGE" ) )
Best Regards,
Dale
Hi @Anonymous,
Could you please mark the proper answers as solutions?
Best Regards,
Dale
Done!
Sorry for being late, I was away.
Thank you very much!
Hi @Anonymous,
Try this formula, please.
Table = CALCULATETABLE ( SUMMARIZE ( DVENDAS; DVENDAS[Ticket]; DVENDAS[Agency]; DVENDAS[ServiceDate]; DVENDAS[Service]; DVENDAS[Source]; DVENDAS[[Destination]; DVENDAS[Status] ); FILTER ( DVENDAS; DVENDAS[Agency] IN { "SITE"; "PORTAL" } && DVENDAS[Status] = "CHANGE" ) )
Best Regards,
Dale
Thanks a lot, @v-jiascu-msft!
And what if I want to filter by [Agency] equals "SITE" and "PORTAL" AND [Status] equals "CHANGE" AND [SalesType] equals "PTA"?
Hi @Anonymous,
You can add more conditions to the filter part. Which table is [SalesType] in?
Table = CALCULATETABLE ( SUMMARIZE ( DVENDAS; DVENDAS[Ticket]; DVENDAS[Agency]; DVENDAS[ServiceDate]; DVENDAS[Service]; DVENDAS[Source]; DVENDAS[Destination]; DVENDAS[Status] ); FILTER ( DVENDAS; DVENDAS[Agency] IN { "SITE"; "PORTAL" } && DVENDAS[Status] = "CHANGE" && DVENDAS[SalesType] = "PTA" ) )
Best Regards,
Dale
Hi All,
I am having a similar issue but instead of filtering like this
FILTER ( DVENDAS; DVENDAS[Agency] IN { "SITE"; "PORTAL" } && DVENDAS[Status] = "CHANGE" && DVENDAS[SalesType] = "PTA" )
I would like to filter :
FILTER ( DVENDAS; DVENDAS[Status] = SELECTEDVALUE(Dvendas[STATUS]) )
Having a Slicer with all the values for Dvendas[STATUS] for the user to select. This does not work, for some reason it doesn't filter.
Do you know why Filtering with a SELECTEDVALUE instead of with a specific text "CHANGE" does not work in this situation ?
Thanks a lot.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
246 | |
119 | |
114 | |
86 | |
70 |