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 everyone,
Currently, on my Report View, I have a table like below.
I want to create a measure, that I will use as a filter TRUE/FALSE.
The condition will be like:
condition 1: If [Code] is {blank} and [Amount] is {blank} then it will TRUE
condition 2: If [Code] have value and [Amount] have value then it TRUE
condition 3: If [Code] have value and [Amount] is {blank} then it FALSE
Please help me!!!!!!!!!! Thanks everyone
you can create a column
Proud to be a Super User!
Hi, thanks for your replied.
But in my case [Amount] is a measure, and [Code] is a text. Also, it's not on the same table. The table I show you is from the Report View, it come from 2 table. So, my problem here that how I can create measure with those condition for the table in Report View like that.
i think you can do something like below, pls have a try
Proud to be a Super User!
Can it put it to filter like this a filter only True
i changed true false to 1 and 0
Proud to be a Super User!
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 |
---|---|
106 | |
104 | |
79 | |
68 | |
61 |
User | Count |
---|---|
144 | |
104 | |
103 | |
82 | |
70 |