topic Re: Slider data for multiple tables in DAX Commands and Tips

Slider data for multiple tables

pagliaci — Wed, 20 Oct 2021 14:47:48 GMT

Hello!

I have 4 tables with the answers from a form and the date it was completed (1column is the answer and 1 clumn the date)

For example:

Those tables are not originally related between them.

My goal is to create one slider to show the amounts of "YES" on each answer in the specific date and this should filter those 4 tables at once. I tried to create a new table that gets all the dates and I related my 4 tables to this 5th. But I cannot activate my relationships, so I am trying to create a mesure with USERELATIONSHIPS on my cart. But this is not going well:

Mistakes = CALCULATE(COUNT(Table 1 [Answer]),(USERELATIONSHIP(Data[Date].[Date],Table1[Date])),Table1[Answer]=""YES")

Does anyone know which would be a best solution?

Thanks a lot!

Re: Slider data for multiple tables

HotChilli — Thu, 21 Oct 2021 00:40:02 GMT

You say "tried to create a new table that gets all the dates" Is this a Dates table created with CALENDAR or CALENDARAUTO? It sounds like that's what you need.

Also is there a way to combine your tables into 1 (in Power Query)? That will make things easier.

Re: Slider data for multiple tables

pagliaci — Thu, 21 Oct 2021 11:25:00 GMT

I ended up making

Erro = CALCULATE(COUNT(LV90[Checklist Desafios 90]), USERELATIONSHIP(LV90[Data], All_Date[Date]), LV90[Checklist Desafios 90]="Erro GCAS/Lote")