Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
On th eimage I tryed to create a measure but the DAX does not find any table in the list. So any time I try to make a reference does not work.
I did try to rename the table, create another table related with the original. But anything work 😞
I am using a SQL Server with Direct Query and those tables are created using Merge function.
Any Clue ?
LM
Solved! Go to Solution.
I'm not 100%sure but if you create a measure with an IF, the conditions in the if should be measures, for that reason you only see one measure that it is your measure claled "recuento.. etc"
In your case, you can create the column with that conditions and then do a measure about the sum or something.
Or you can create the a sumx with some conditions if you one to count something
I'm not 100%sure but if you create a measure with an IF, the conditions in the if should be measures, for that reason you only see one measure that it is your measure claled "recuento.. etc"
In your case, you can create the column with that conditions and then do a measure about the sum or something.
Or you can create the a sumx with some conditions if you one to count something
Very Interesting
Well, I very new on this of PowerBI and I dod not know about this limitation. I will do it as you say.
Thanks
LM
other example, assuming that you are count the values that match with other column with 1. you can do something like this
MEASURE = CALCULATE (COUNT(table[column to count]), FILTER(TABLE, TABLE[yourcolumnfilter]=1))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
179 | |
108 | |
104 | |
71 | |
70 |