The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I try to Countif how many times the numbers of value's in one colum exist, if the same value exits in an other colum..
Any one who can help?
Thanks Ellen
Solved! Go to Solution.
Hi @EllenBakker ,
I created a sample pbix file(see attachment), please check whether that is what you want.
1. Create a measure as below to get the number of repetitions of name1
Countif = CALCULATE(COUNT('Table'[name1]),ALLEXCEPT('Table','Table'[name1]))
2. Create a measure as below to judge if the same value for name1 exist in name2
name1 exist in name2? =
VAR _tab =
VALUES ( 'Table'[name2] )
RETURN
IF ( SELECTEDVALUE ( 'Table'[name1] ) IN _tab, 1, 0 )
If the above one can't help you get your expected result, please provide some sample data with Text format and your expected result with calculation logic and special example explanation. Thank you.
Best Regards
Hi @EllenBakker ,
I created a sample pbix file(see attachment), please check whether that is what you want.
1. Create a measure as below to get the number of repetitions of name1
Countif = CALCULATE(COUNT('Table'[name1]),ALLEXCEPT('Table','Table'[name1]))
2. Create a measure as below to judge if the same value for name1 exist in name2
name1 exist in name2? =
VAR _tab =
VALUES ( 'Table'[name2] )
RETURN
IF ( SELECTEDVALUE ( 'Table'[name1] ) IN _tab, 1, 0 )
If the above one can't help you get your expected result, please provide some sample data with Text format and your expected result with calculation logic and special example explanation. Thank you.
Best Regards
Please provide some mock data along with expected result, so someone can suggest a specific solution.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 July 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
112 | |
69 | |
48 | |
43 |
User | Count |
---|---|
188 | |
87 | |
77 | |
74 | |
60 |