Forum Discussion
Compare columns from two different tables
Hi gsamaral77
Sure. I know your problem should be that when you add my count measure into card visual it will show blank unless you select an order in table visual.
Try to build a new measure sum as below.
SUM = SUMX(SUMMARIZE(TAB1,TAB1[ID],TAB1[Nome do recurso],TAB1[Válido até]),[Count Ordem])You can use month, date or other columns in TAB1 to build slicers to filter your measures.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, thanks for keep trying help me kkk
In this dashboard the ideia is not look for the orders separately, but the amount that was perfomed by the scheduled workers in the scheduled date
With this measure only work in a table with column order and this measure but if I put in a Card for show the total just appear "in blank", only if I selected some order than count, but the users in this dashboard won't filter by the order, will filter by the date, workers etc
Do you know if is that possible? I new in DAX, don't know much about it rs
Hi gsamaral77
Sure. I know your problem should be that when you add my count measure into card visual it will show blank unless you select an order in table visual.
Try to build a new measure sum as below.
SUM = SUMX(SUMMARIZE(TAB1,TAB1[ID],TAB1[Nome do recurso],TAB1[Válido até]),[Count Ordem])You can use month, date or other columns in TAB1 to build slicers to filter your measures.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That worked!! Thank you very much, I was trying to do that at least 3 weeks kkk You helped me a lot!!