Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Can you please let me know if the following sql should give the same result as the followed DAX?
Thank you
select
p.[field1], count(distinct p.[field3]) AS "Mycount"
from
TableP AS p
INNER JOIN TableH AS h ON p.ID = h.ID
where
h.[field7] > 0
AND p.[field2] = 'some text'
group by
p.[field1]
having count(distinct p.[field3]) >= 2
--------------------------------------------------------
FILTER (
SUMMARIZE (
'TableP'
,'TableP'[field1],
'TableP'[field2],
"Mycount", DISTINCTCOUNT ( 'TableP'[field3] ),
),
[price] > 0
&& SEARCH ( "some text", 'TableP'[field2], 1, 0 )
&& not ISBLANK('TableP'[field3])
&& [MyCount] >= 2
)
Solved! Go to Solution.
You can go ahead with anything as long as it's giving the correct result.. 🙂
Thanks.
Try to use below DAX. Just replace your table and column names.
You can add more filters too.
FILTER( CALCULATETABLE( SUMMARIZECOLUMNS(DimProduct[EnglishProductName], DimProduct, "Mycount", DISTINCTCOUNT( FactInternetSales[OrderDate]) ) ), CALCULATE(DISTINCTCOUNT( FactInternetSales[OrderDate])) >= 3 && DimProduct[EnglishProductName]="some text" )
Thanks.
Hi,
This seems to be giving the similar result to my filter and summarize dax
You can go ahead with anything as long as it's giving the correct result.. 🙂
Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |