Select values based on conditions

[Krcmajster]

So I have 3 tables, one with locations and 2 with sales and dates. My dev didn't created dates tabel, so my question is:

Can you use dax to select columns based on condition, and that would be vendor from locations table ? e.g. if Vendor is Ven1 then use dates and sale amounts from Sales1 table and if Vendor is Ven2 then use data from Sales2. I would like to use this on axis in chart and slicer. I can't create column since it's in Azure

[VasTg]

@Krcmajster 

I can't create column since it's in Azure

A measure cannot be used in in a chart or slicer. It has to be a column.

where are you creating the report? Is your source a dataset?

If it helps, mark it as a solution

Kudos are nice too

[jstorm]

If the tables are related you could use an IF() based on your vendor.  For example:

IF( [vendor] = "Ven1",
    CALCULATE( SUM( 'Sales1'[Sales] ), 'Sales1'[Dates] ),
    CALCULATE( SUM( 'Sales2'[Sales] ), 'Sales2'[Dates] )
)

(If the vendor is "Ven1" uses first calculate function with Sales1 table, else, use second calculate with Sales2 table.)

[shebr]

Hi @Krcmajster 

I believe this is possible, can you provide a subset of data so that I can look at a relevant measure? I I need a bit more information about the vendor and sales values and how they are currently stored.

Thanks

[Krcmajster]

@shebr Best I could do. The tables are not the same and the connection is more complicted but I can solve this if I have solution for this

[Anonymous · Accepted solution]

Hi @Krcmajster ,

If i understand you correctly, you can use UNION() function to create a calculated table which contains table1 and table2 then use vendor as silcer if you want.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.