March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello community!
I have a task, need your help to solve it.
We have two tables, one of them - date and month; second - customer and product ID's, number of line.
Based on one month (february) our goal is to count how many rows do we have in this month but with specific conditions:
1) If data in collum "contract" = "own production", "trading", then we count all those rows seperately as unique ones
2) If data in collum "contract" <> "own production", "trading", then we consider only unique data. For example we have 3 rows with same number 1817, in this case we count only as 1 unique row
In example (february) we have 22 rows. So the goal in our example, considering conditios I mentioned abowe, should be 19 unique rows
Example file pbix
Thank you in advance!
Solved! Go to Solution.
Hi,
Please check the below picture and the measure.
fix measure =
VAR conditiontable =
FILTER ( Plan, Plan[Contract] IN { "Own production", "Trading" } )
VAR nonconditiontable =
SUMMARIZE ( EXCEPT ( Plan, conditiontable ), Plan[Contract] )
RETURN
COUNTROWS ( conditiontable ) + COUNTROWS ( nonconditiontable )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
In this example, you can use an IF() statement to check whether the column has the value you wish, and then returns a different count depending on it.
"IN()" checks the value against a list of values.
EG
Hi,
Please check the below picture and the measure.
fix measure =
VAR conditiontable =
FILTER ( Plan, Plan[Contract] IN { "Own production", "Trading" } )
VAR nonconditiontable =
SUMMARIZE ( EXCEPT ( Plan, conditiontable ), Plan[Contract] )
RETURN
COUNTROWS ( conditiontable ) + COUNTROWS ( nonconditiontable )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Ні, @Jihwan_Kim
Thanks for the help, your measure worked
Greetings from Ukraine.
User | Count |
---|---|
30 | |
19 | |
15 | |
14 | |
10 |