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 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
Solved! Go to Solution.
i changed true false to 1 and 0
Proud to be a Super User!
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
92 | |
86 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |