Forum Discussion
sql query to dax equivalent
Hello, I've been trying to solve an issue with my current dashboard and can't seem to find a solution. I have the right result when i check it on the database side with sql, but I just seem to be u...
For someone looking for a possible solution to their problem, i eventually found it.
similar to what amitchandak did but with a little tweak.
countx(filter(values(dbw_inv_projecto[nome]),calculate(distinctcount(dbw_inv_proj_etapa[dimensao]))> 1),calculate(distinctcount(dbw_inv_proj_etapa[dimensao])))the end result can be presented in a card. but if you're looking for input forfor a table, use amitchandak 's solution.hope this helps someone.
amitchandak, thanks for the reply
but i think there is something missing from your solution.
when you use "filter(values(projecto[nome]), > _1)"
i assume you meant something like: filter(values(projecto[nome]), _1> 1).
if my assumption is right, it still gives me the wrong result.
it is giving me the total sum of "dimensao" for all projects instead of giving me the intended result.
For someone looking for a possible solution to their problem, i eventually found it.
similar to what amitchandak did but with a little tweak.
countx(
filter(
values(dbw_inv_projecto[nome]),
calculate(
distinctcount(dbw_inv_proj_etapa[dimensao])
)> 1
),
calculate(distinctcount(dbw_inv_proj_etapa[dimensao]))
)
the end result can be presented in a card. but if you're looking for input for
for a table, use amitchandak 's solution.
hope this helps someone.