Forum Discussion
Select text value from a variable table - DAX
VAR _vGetMax = CALCULATETABLE( SUMMARIZECOLUMNS( Mytable[brand], mytable[groups], 'Perfect Experience - Charts'[Sort], "@prodcount", [Prod Count]), DATESBETWEEN('Calendar Table'[Date], DATEAD...
Hi abimfol ,
So far, the created virtual table cannot be used for filtering. You can try to create the virtual table in the formula as a physical table, and then filter
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.