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.
Measure1 = Calculate(
SUM(movement[pcena]);
FILTER(movement; movement[date] >= NOW()-30 && movement[date] <= NOW()))
Measure2 = Calculate(
SUM(movement[pcena2]);
FILTER(movement; movement[date] >= NOW()-30 && movement[date] <= NOW()))
Measure3=IF([Measure1]<>0,[Measure1]/[Measure2],0).
Can you tell me, where is the mistake in syntax in Measure3.
measure 1 = CALCULATE(SUM(movement[date]); movement[date]>NOW()-30; movement[date] <= NOW()).
Can you tell me ,what the difference bettweenn Measure1 a measure 1 is?
Problem 2
I have two tables with relation in query.
A->B
Table A includes column Office and revenue.
Table B includes column Office and parameter.
I want to create report Office Revenue/parameter . How will I create it in DAX.
I need this solve fast as I can.
Solved! Go to Solution.
@pstanek This should work for a Calculated Column in Table A
Column = TableA[Pcena] * RELATED ( TableB[Parameter_n] )
@pstanek Besides that . at the end of Measure3 there's nothing wrong with that formula
The difference between Measure1 and measure 1 - is the evaluation context - best way to explain/show is with a picture
Measure1 is the way to go even tough you get the same overall result in the bottom Total Row
Go to the Relationship View => select Column Office in either table => drag and point to column Office in the other table
The relationship will be established
Hope this helps. Le me know...
Can you tell new, which one is faster? Measure1 , or measure1
I have data, where Measure 1 is too slow. Results are not often calculated. I can even tell, I am at BI mercy, If results appear, or not.
Measure 3 didn´t t work. Sometimes It writes something about function filter, that I can not be used in fuctions If and similar functions
I have already established relationship, but i don´t know How to create column in Table A .
Table a
Office1 goods1 Pcena1
Office1 goods2 Pcena2
Office2 goods1 Pcena3
Table B
Office_n parameter_n
Column should have values
Pcena*VLooklup(office_ n)
It means
Office1 goods1 Pcena1 Pcena1*VLooklup(office_ 1)
Office1 goods2 Pcena2 Pcena2*VLooklup(office_ 1)
Office2 goods1 Pcena3 Pcena3*VLooklup(office_ 2)
Vlookup will find parameterin Table B
@pstanek This should work for a Calculated Column in Table A
Column = TableA[Pcena] * RELATED ( TableB[Parameter_n] )
Thanks, I was stepping around.
Do you know some really good Dax library or books for Power Bi. I mean, I would like to see not only codes, but with easy examples.
Tables, what we want to calculate., results
I always find code, tables - not described in detail where I can not say what It means. Result is that, I know function related, but I can not use it effectively.
These are great DAX sites/resources: (and their authors have also published books)
http://www.sqlbi.com/books/the-definitive-guide-to-dax/companion/
http://www.powerpivotpro.com/the-book/
http://exceleratorbi.com.au/learn-to-write-dax/
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 |
---|---|
105 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |