Forum Discussion
Add filter based on value to formula
Hi! I'm new to Power BI and I have a question regarding a formula. I have two queries (via web, JSON) with two different subscriptions we offer. In the datasheets, there is a column with "Status...
Thank you! Work's perfect! But there is happening something weird now. In the measure you created, I get a total row of 1161. But when I use a Q&A and ask "Count active PlanA members" and a different Q&A for "Count active PlanB members", the total of those two combined is 1313.
I understand this can have many reasons, but do you have a suggestion?
flipfis
I have not tested with Q&A. Once you combine the two tables, you still have those original tables which could be used by the Q&A engine. I think you should try to combine the tables in Power Query or at the source level if Q&A is your concern.
You can also try setting up synonyms in the table properties to handle questions in Q&A.