Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Guys,
I Want to count the results of my measure, but i don't now how., i need to know how much products i have in each classification.
The measure basically classifies the results of differences between two dates.
Solved! Go to Solution.
@renatoremondi So, in general you would do something along the lines of this:
Zero to Seven =
VAR __Table = ADDCOLUMNS(SELECTCOLUMNS('Table',"__ProductID",[ProductID]),"__Class",[test])
RETURN
COUNTROWS(FILTER(__Table,[__Class] = "00-07"))
Hard to be more specific without sample data.
@renatoremondi So, in general you would do something along the lines of this:
Zero to Seven =
VAR __Table = ADDCOLUMNS(SELECTCOLUMNS('Table',"__ProductID",[ProductID]),"__Class",[test])
RETURN
COUNTROWS(FILTER(__Table,[__Class] = "00-07"))
Hard to be more specific without sample data.
It worked well, thank you very much. 😎
This is a preview of my data.
I will try what you say