cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Determine which conditions are met in capabilities.json and read values by datarole name

Hi,

 

Assume I have the following two conditions specified in capabilities.json below.

  1. What is the proper way to determine which of the two conditions is satisfied (or none)?
  2. Is there a way to retrieve the values of a field (from options.dataView) by its data role name rather than by an index?
"conditions": [
	{
		"ltd": {
			"min": 1,
			"max": 1
		},
		"lng": {
			"min": 1,
			"max": 1
		},
		"zip": {
			"max":0
		}
	}
]

and

"conditions": [
	{
		"ltd": {
			"max": 0
		},
		"lng": {
			"max": 0
		},
		"zip": {
			"min": 1,
			"max": 1
		}
	}
]

Thanks,

Martijn

 

 

 

 

1 ACCEPTED SOLUTION
Super User I
Super User I

Hi @Blaenzo - for question #2, we had a similar post the other day - does this response cover-off your question? If not, let me know and I'll see if I can help fill in any gaps.

Good luck,

Daniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


My course: Introduction to Developing Power BI Visuals




View solution in original post

3 REPLIES 3
Super User I
Super User I

Hi @Blaenzo - for question #2, we had a similar post the other day - does this response cover-off your question? If not, let me know and I'll see if I can help fill in any gaps.

Good luck,

Daniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


My course: Introduction to Developing Power BI Visuals




View solution in original post

Hi @dm-p ,

 

Yes, that worked. Thanks very much.

The filter statement also works nicely with data roles that accept multiple fields as it returns an array of all fields.

From here you can indeed work out which conditions have been met.

 

Thanks,

Martijn

The code linked in the previous answer also shows my approach to 'testing' for conditions once I get the column metadata, which may help with solving question #1 - if you have multiple conditions, then you can create flags to indicate suitable scenarios and perhaps branch on those using a switch statement or simialr, depending on the complexity of your view model.

If you need further advice, let me know and I'll try and mock something up when I get back into the office next week. 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


My course: Introduction to Developing Power BI Visuals




Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.